COUNTIF Help

TheKutts

New Member
Joined
Apr 24, 2019
Messages
9
Hi, I am a first time poster in this forum. I have an issue regarding the COUNTIF formula:-

I have a column containing codes and text - for example - "00000 - To be confirmed".
Some rows in the column contain two or more codes and text separated by a semi-colon - for example - "95950 - Finger injury; 95960 - Hip and thigh injury"/
I need to count the number of times a code appears in the column and there is 129512 rows and the formula I am using is as follows:-
=COUNTIF($K$2:$K$129513,"*00000*")

If I use the formula above, I would need to change the code in the formula manually but there is about 4800 codes. What I would like to do is:-
- Strip the codes out of column K into column L and then use a COUNTIF formula to reference the codes in column L - something like:-

=COUNTIF($K$2:$K$129513,L2) - so that the formula searches column K2 to K129513 using L2 as the criteria.

Any help would be appreciated.
I am using Excel 2010.
Thank you.
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,225,739
Messages
6,186,746
Members
453,370
Latest member
juliewar

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
Back
Top