Search the help for the Countif function.
Didn't see the spreadsheet. The formula would be something like - =countif(b2:b500,"Annette Ernst")
This would count every time that column B has "Annette Ernst" in it. b2:b500 is the range of criteria that it would be looking in, "Annette Ernst" is what it will be looking for, and couting how many cells that is in.
If this is data that you need to count everyday, let me know and I can throw together a spreadsheet that you can just copy and past into, and it will count everything as soon as you hit enter.
Originally posted by AbecX
I always thought grammer and spelling were some of the more important aspects in life, I mean after all, without it, we would all be doing your job for a living.
Last edited by Brad88gt; 01-22-2009 at 06:40 PM.