SUMPRODUCT formula help
The formula is fine. You must have a #N/A in the data between 15 and 188.
Find it and correct it.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Serge" wrote in message
...
The formula below was working when D188 was D14 because I had entries from
D9
to D14, but when I copied down to row 188 where there is no data yet, it
created a "#N/A" for result. I need to have those cell without data to be
included in the formula.
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))
|