Inconsistance Formula?

T

Tmt

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"))
 
E

Eduardo

Hi,
formula look Ok, check if in the data is left out you don't have any spaces,
test something, from the data id being picked up copy the work and the number
from there and see what happens if that doesn't solve your problem could you
post an example
 
F

Fred Smith

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top