ExcelBanter - Sumproduct giving #NA

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sumproduct giving #NA (https://www.excelbanter.com/excel-worksheet-functions/102910-sumproduct-giving-na.html)

Gary

Sumproduct giving #NA

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

Sumproduct giving #NA

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" wrote in message
...
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

Sumproduct giving #NA

Thanks Bob

I realized that after posting the question. Sorry.

"Bob Phillips" wrote in message
...
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" wrote in message
...
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.

All times are GMT +1. The time now is 10:52 PM.