In your particular stated case, this should work. Modify to suit.
=SUMPRODUCT((LEFT(G2:G22,2)={"p1","a1"})*H2:H22)

--
Don Guillett
SalesAid Software

"Robert" wrote in message
...

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$1008))

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