Counting names

Copper Contributor

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.

6 Replies

@nicklesontool ,

 

That could be like

=SUMPRODUCT(ISNUMBER(SEARCH("Name",$A$1:$D$1))*1)

@Sergei Baklan thank you.

 

were do i put the search criteria?

@nicklesontool 

 

That's like this

image.png

but I have no idea how is your data looks like

@Sergei Baklan I have attached the file for your reference.

 

I need to know how many times an employee's name appears in a cell.

 

I tried your formula and it did not work for me. 

Try this:
=COUNTIF(A2:Y55,"*EMPLOYEE NAME HERE*")

@nicklesontool 

@nicklesontool 

 

Both above formulas work

image.png

Please check attached.