Sumproduct giving #NA

G

Gary

Hi All,

the following formula is giving me an #NA error. Can anyone tell me where am
I wrong?

=SUMPRODUCT((July!E3:E153='GLASS REPORT'!A10)*(July!R3:R152='GLASS
REPORT'!D2)*July!O3:O153)

Thanks in advance.
 
B

Bob Phillips

The ranges have to be the same size. Yours are different, E3:E153 and
R3:R152

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top