Look up for specific data

siirma

New Member
Joined
Jul 10, 2013
Messages
37
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
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

bcarcamo

New Member
Joined
Jan 24, 2014
Messages
3
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")
 

Watch MrExcel Video

Forum statistics

Threads
1,127,677
Messages
5,626,220
Members
416,168
Latest member
tttt199623

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top