Welcome to the Board Tim!
John's Pivot Table suggestion is a great idea. Depending on your layout/structure, you might also want to check the helpfile for COUNTIF.
And feel free to post a shot of your sheet (there's a sticky on the main Excel forum page that'll show you how to do that).
HTH,