Robert wrote:
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
1.
=SUMPRODUCT(ISNUMBER(MATCH($F$4:$F$1008,{"P1","R1" ,"U1","X1"},0))-ISNUMBER(MATCH($F$4:$F$1008,{"P1R","R1R","U1R","X1 R","A1R"},0)),--($E$4:$E$1008=$E1015),$Z$4:$Z$1008)
2.
The answer is no.
|