View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary Gary is offline
external usenet poster
 
Posts: 143
Default 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.