Forum Discussion

nicklesontool's avatar
nicklesontool
Copper Contributor
Jun 13, 2019

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...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 13, 2019

nicklesontool ,

 

That could be like

=SUMPRODUCT(ISNUMBER(SEARCH("Name",$A$1:$D$1))*1)
nicklesontool's avatar
nicklesontool
Copper Contributor
Jun 14, 2019

SergeiBaklan thank you.

 

were do i put the search criteria?

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 14, 2019

    nicklesontool 

     

    That's like this

    but I have no idea how is your data looks like

    • nicklesontool's avatar
      nicklesontool
      Copper Contributor
      Jun 14, 2019

      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. 

Resources