How to count occcurence of specific text block in a column

A

Anshuman

I want to count how many times initials of employees (e..g AD, AS, RR, AN,
VB, DO) appear in a specific column. I am using COUNT IF function for that.

The problem is as soon as I put initials fof 2 employees in one cell, the
formula does not recognise either of them.

To give you a gist, I want to see how many people work out of office , so I
have a calendar style worksheet( month=col, date=row). If I input AD on 13
day of jan, , I get 1 for AD, in the row where I am collecting total for AD .
But if I put both AD, AS on 13 jan, then neither AD nor AS gets recognised.

Please advise a suitable formula or an alternative method.
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count the numbers in a Word document? 0
Macro to Select text from a point given to a specific word 2
count the amount of times a two letters appears in text string 3
calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had 2
How can count the number of cells that fulfill certain criteria in other cells 2
How to center adjust text above and image in a two column document. 1
Macro to select and delete levels of a document 2
COUNT function 1

Top