T
Tmt
I've used this formula to calculate the frequency of items being serviced in
many departments from another worksheet. There are 2 cells that won't give me
the correct result. Please help.
=SUMPRODUCT(('Q1 '!E13:E137="Calibrated")*('Q1 '!G13:G137="70223"))
In Q1 70223 has 7 occurances which gives me a result of 7 from this
SUMPRODUCT
=SUMPRODUCT(('Q1 '!E13:E137="Calibrated")*('Q1 '!G13:G137="74532"))
In Q1 74532 has 2 occurances, but the resultance is 0 (instead of 2)
many departments from another worksheet. There are 2 cells that won't give me
the correct result. Please help.
=SUMPRODUCT(('Q1 '!E13:E137="Calibrated")*('Q1 '!G13:G137="70223"))
In Q1 70223 has 7 occurances which gives me a result of 7 from this
SUMPRODUCT
=SUMPRODUCT(('Q1 '!E13:E137="Calibrated")*('Q1 '!G13:G137="74532"))
In Q1 74532 has 2 occurances, but the resultance is 0 (instead of 2)