Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT formula help
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)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
do I need array formula or sumproduct for counting? | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Modify A SumProduct Formula | Excel Worksheet Functions | |||
sumproduct formula to slow | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |