=SUMPRODUCT(--(A2:A200="falls"),--(B2:B200=100))

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"FSmitty" wrote in message
...
I have two columns in a spreadsheet. One column has one word descriptions
e.g. falls, and the other column has the location e.g 100 hall. I want to
compile the number of falls for example that occurred on different halls
e.g
100, 200, 300 halls. Remember that the column with descriptions has
several
descriptions but I just want falls.