Need help counting muliple criteria in same row

[adammcbane]

I am trying to count the number of times that 2 fields of criteria are met in a worksheet. For example if you are listing each time a group of people say a particular word. You have 5 people and 5 words, but only want to count when 1 person says 1 particular word. List of names is in one column, and list of words is in another. Want to count each time in same row. What would you use?

 

[Domenic]

If you're using Excel 2007 or later, COUNTIFS can be used. For earlier versions, SUMPRODUCT can be used. Have a look here for an example...

http://xl-central.com/count-multiple-criteria.html

 

[adammcbane]

Worked great, thanks!