Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |