Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT formula expanded from original
('Bolt List'!$H$9:$H$188="1") This part was added to the formula below to
introduce one more criteria and it does not work at the moment but it did before the extra criteria. column "H" could be empty or it could have numerical value, the value has no importance but the formula needs to recongnise an entry. Can anyone help with this formula? Thank you in advance. Serge =SUMPRODUCT(('Bolt List'!$D$9:$D$188=K8)*('Bolt List'!$J$9:$J$188=L8)*('Bolt List'!$E$9:$E$188="A325 Black.")*('Bolt List'!$H$9:$H$188="1")*'Bolt List'!$C$9:$C$188) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
DIV/0! error in SumProduct formula with no division | Excel Worksheet Functions | |||
Shorten sumproduct formula | Excel Discussion (Misc queries) | |||
adding two sumproduct formulas together | Excel Worksheet Functions |