Bob,
Now to add to the formula, Lets say that the 100 hall has a range of room
numbers from 100 to 199. I want to count all the "falls" that occurred within
that range of numbers (100 to 199). When I use the formula
=SUMPRODUCT(--(A:A200="falls"),--(B2:B20099<200)), I get #VALUE as an answer
to the formula instead of a count.

"Bob Phillips" wrote:

=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.