Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMPRODUCT - How to combine
A1=SUMPRODUCT(($F$4:$F$1008={"P1","R1","U1","X1"}) *(($E$4:$E$1008)=$E1015)*($Z$4:$Z$1008))
B1=SUMPRODUCT(($F$4:$F$1008={"P1R","R1R","U1R","X1 R","A1R"})*(($E$4:$E$1008)=$E1015)*($Z$4:$Z$100 8)) C1= A1-B1. The above formulas work. 1. Can someone combine the two into 1 formula (for neatness in the worksheet). 2. should ctrl+shift+enter be applied Thank you in advance. RobertR. (there is another Robert aswell in the forum |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT help | Excel Worksheet Functions | |||
Another Sumproduct & #N/A problem | Excel Worksheet Functions | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |