Forum Discussion
nicklesontool
Jun 13, 2019Copper Contributor
Counting names
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 a...
nicklesontool
Jun 14, 2019Copper Contributor
SergeiBaklan
Jun 14, 2019Diamond Contributor
- nicklesontoolJun 14, 2019Copper Contributor
SergeiBaklan 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.
- SergeiBaklanJun 14, 2019Diamond Contributor
- PReaganJun 14, 2019Bronze Contributor
Try this:
=COUNTIF(A2:Y55,"*EMPLOYEE NAME HERE*")
nicklesontool