Look up for specific data

[siirma]

Hi there,

i have a big list in excel of all different information, in one cell in excel, ie:

3 interest, 2 rates, 4 same day, 90 next day
1 tax, 8 tax, 9 pass, 8 fail
34 fails, 3 deliver, 80 interest, 1 same day
4 pass, 5 acct, 9 adj, 7 next day...

and so on, the list goes on over column B for example.

so i want to look up how many counts are there for just for example "tax", i would like to know how many times word tax comes up in that column.

I tries =COUNT(B:B, "tax") but it returns only one

is there any easier way to do it, except using conditional formating?

Thanks

 

[bcarcamo]

The =COUNT function only counts the number of cells that contain numbers. If you want to use a condition, try the =COUNTIF function. For your particular example, try =COUNTIF(B:B, "Tax")