Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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")) |