ExcelBanter - SUMPRODUCT

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SUMPRODUCT (https://www.excelbanter.com/excel-discussion-misc-queries/82526-sumproduct.html)

The formula below was working fine when D188 was D14 because there is data in
those rows. But when I copied down to row 188 I got A "$N/A" for answer.
I need to include cells that do not have data enties yet in them.
Can someone help with this problem?
Many thanks in advance.
Serge

=IF(OR(A32="",B32=""),"",SUMPRODUCT(('Bolt List'!$D$9:$D$188=A32)*('Bolt
List'!$J$9:$J$188=B32)*('Bolt List'!$E$9:$E$188="SAE Gr.5 Min. Cad.
Plated"),'Bolt List'!$C$9:$C$188))

See other thread.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Serge" wrote in message
...
The formula below was working fine when D188 was D14 because there is data
in
those rows. But when I copied down to row 188 I got A "$N/A" for answer.
I need to include cells that do not have data enties yet in them.
Can someone help with this problem?
Many thanks in advance.
Serge

=IF(OR(A32="",B32=""),"",SUMPRODUCT(('Bolt List'!$D$9:$D$188=A32)*('Bolt
List'!$J$9:$J$188=B32)*('Bolt List'!$E$9:$E$188="SAE Gr.5 Min. Cad.
Plated"),'Bolt List'!$C$9:$C$188))