ML089

¦^´_ 1# vvcvc

2.
=SUMPRODUCT(A:A="P")+....+SUMPRODUCT(A:A="S")

¥i¥H­×§ï¬°

=SUMPRODUCT(COUNTIF(A:A,{"P",...,"S"}))

ML089

¦^´_ 5# vvcvc

¦pªGª¬ªp¬O¦h­«±ø¥ó
=SUMPRODUCT((A:A="P")*(B:B="V"))+....+SUMPRODUCT((A:A="S")*(B:B="V"))

­×§ï¬°
=SUMPRODUCT(COUNTIFS(A:A,{"P", ... , "S"}, B:B,"V"))

ML089

=SUMPRODUCT(SUMIFS(
Sheet2!$P$2:$P$1488,
Sheet2!$A$2:$A$1488,E$3&"*",
Sheet2!$T$2:$T$1488,"<="&DAY($B$2+1),
Sheet2!$B$2:$B$1488,RIGHT(E$2,3),
Sheet2!$S$2:$S$1488,{"*_??","*T??"}))

ML089

¦^´_ 12# vvcvc

=SUMPRODUCT(COUNTIFS(A:A,{"P","S"},B:B,{"V";"U"}))