I suspect your problem is the numbers (70223, 74532, 74533). By enclosing
them in quotes, you're looking for text, not numbers. Are they always going
to be text in the Q1 sheet?

Regards
Fred

"Tmt" wrote in message
...
I used this formula to calculate the number of items being serviced in any
particular department from another worksheet. It counts most of my data
but
leave out some. Please help. Thanks.

=SUMPRODUCT(('Q1 '!E13:E136="calibrated")*('Q1 '!G13:G136="70223"))
=SUMPRODUCT(('Q1 '!E13:E136="calibrated")*('Q1 '!G13:G136="74532"))
=SUMPRODUCT(('Q1 '!E13:E136="calibrated")*('Q1 '!G13:G136="74533"))