Formulas

Occasional Visitor

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?? 

1 Reply
=COUNTIF( range, criteria ) for example =COUNTIF ( A1:A100, "Dave Appleton")