If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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")) |
#2
|
|||
|
|||
Inconsistance Formula?
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 "Tmt" wrote: 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")) |
#3
|
|||
|
|||
Inconsistance Formula?
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")) |
Thread Tools | |
Display Modes | |
|
|