Aladin Akyurek, thank you. The "A1" was omitted in the first array. Once
corrected gave the correct number.

=SUMPRODUCT(ISNUMBER(MATCH($F$4:$F$1008,{"P1","R1" ,"U1","X1","A1"},0))-ISNUMBER(MATCH($F$4:$F$1008,{"P1R","R1R","U1R","X1 R","A1R"},0)),--($E$4:$E$1008=$E1015),$Z$4:$Z$1008)

Don Guillett, thank you also for the short formula. I had to modify to suit
my sheet. It seems to work but there is a hitch:arrays "P1","R1"... and
"P1R","R1R"..are being summed instead of being subtracted. In case you want
to check further, your formula as modified

=SUMPRODUCT((LEFT(F4:F1008,2)={"P1","A1","R1","U1" ,"X1","E1","I1","J1"})*((E4:E1008)=E1015)*(Z4:Z100 8))
Once again thank you both.
RobertR