Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-3512018%22%20slang%3D%22en-US%22%3EFormulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3512018%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20of%20employee%20ID%20numbers%20and%20names%2C%20I%20need%20a%20formula%20to%20count%20how%20many%20times%20a%20certain%20name%20is%20listed.%20How%20can%20I%20do%20this%3F%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3512018%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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")