Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT
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)) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with sumproduct & dynamic ranges | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |