Sumproduct giving #NA

[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.

 

[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)

 

[Gary]

Thanks Bob

I realized that after posting the question. Sorry.