Counting names

Question

I have a spreadsheet/calendar with employee names on the days they are taking off for vacation.

I am trying to find a way to have a count of how many times a name appears in any cell even if it already contains other names.

I could have 4 guys taking the same day off but I cannot seem to create a formula to have it count the name.

Thanks in Advance.

sergeibaklan · Answer

nicklesontool&nbsp;,
&nbsp;
That could be like
=SUMPRODUCT(ISNUMBER(SEARCH("Name",$A$1:$D$1))*1)

nicklesontool · Answer

SergeiBaklan&nbsp;thank you.&nbsp;were do i put the search criteria?

sergeibaklan · Answer

nicklesontool&nbsp;
&nbsp;
That's like this

but I have no idea how is your data looks like

nicklesontool · Answer

SergeiBaklan&nbsp;I have attached the file for your reference.&nbsp;I need to know how many times an employee's name appears in a cell.&nbsp;I tried your formula and it did not work for me.&nbsp;

preagan · Answer

Try this:=COUNTIF(A2:Y55,"*EMPLOYEE NAME HERE*")nicklesontool&nbsp;

Forum Discussion

Counting names

6 Replies

Resources