counting two different values in a column and retuning the count of that value

[Ewesto]

Hi, new here I'm trying to write a formula for the cells in column B that will look at the line in column c and count how may times the word Flat or Inc has occurred before (top down). The issue I am running into is how to I tell it if Flat is not found look for "inc" and count the Inc and return that count of "Inc" Example cell B4 would return 1 since that is the first time "Inc" was found.

I was trying to use COUNTIF open to any other way to do this. workbook sample attached. thanks in advance

[WideBoyDixon]

Is it just this?

Please Login or Register  to view this content.

WBD

[Ewesto]

That seems to work I'm going to put it in the larger workbook and test. Thanks I'm not sure what it is doing I was thinkin i would have to call out the words Flat and Inc to make it work. Will let you know after testing

[Ewesto]

Is it just this?

Please Login or Register  to view this content.

WBD

Worked great thanks