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