# Look up for specific data

#### siirma

##### New Member
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

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### bcarcamo

##### New Member
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")

Replies
10
Views
185
Replies
1
Views
94
Replies
3
Views
98
Replies
26
Views
573
Replies
6
Views
458

1,127,595
Messages
5,625,697
Members
416,128
Latest member
WarJamAnd

### 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.

### Which adblocker are you using?

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

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