Forum Discussion

ShawnaG's avatar
ShawnaG
Copper Contributor
Jun 15, 2022

Formulas

I have a list of employee ID numbers and names, I need a formula to count how many times a certain name is listed. How can I do this?? 

  • mtarler's avatar
    mtarler
    Silver Contributor
    =COUNTIF( range, criteria ) for example =COUNTIF ( A1:A100, "Dave Appleton")

Resources