Thread
:
Sumproduct giving #NA
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Gary
external usenet poster
Posts: 143
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.
Reply With Quote
Gary
View Public Profile
Find all posts by Gary