Thread: Inconsistance Formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TMT TMT is offline
external usenet poster
  
Posts: 13
Default Inconsistance Formula?
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"))
Reply With QuoteReply With Quote