G
Guest
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))
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))