ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ´M¨D±ø¥ó¤½¦¡´î¼Æ

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2019-5-11 11:37 ½s¿è

=SUMPRODUCT(($B$2:$B$65536=B2)*($C$2:$C$65536=C2),$E$2:$E$65536)-SUMPRODUCT(($B$2:$B$65536=B2)*($C$2:$C$65536=C2),$G$2:$G$65536)
ù

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD