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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>

[Gary]

Thanks Bob

I realized that after posting the question. Sorry.


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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.
>>
>>
>
>