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

½Ð°Ý²Å¦X¦h±ø¥ó¥[Á`­p

½Ð°Ý²Å¦X¦h±ø¥ó¥[Á`­p

´X­Ó±ø¥ó¦¡¥[Á`°ÝÃD¡A°Ñ¦Òºô¸ô¤W²³¦hµo°Ý¤Î¸Ñµª¡A«o¤@ª½µLªk¿Ä·|³e³q¡A
¦]¦¹µo°Ý½Ð±Ð«e½ú¨D¸Ñ¡A·PÁ°Õ~~~
°ÝÃD敍­z©óªþÀɲέpªí-1¤Î²Î­pªí-2¤¤¡C

TEST.rar (10.74 KB)

«Ü©êºp¡A¦]¬°¤@¬q®É¶¡¨S¤W³Â»¶®a±Ú¡A
·s¯¸­«·sµù¥U¡A©Ò¥H²{¶¥¬q¤p¾Ç¥Í¨­¥÷µLªk¤U¸üªþÀÉ¡A
³Â·Ð«e½ú¸Ñµª®É¤£­n¥ÎªþÀɤ覡¡A¦]¬°¤£¯à¤U¸ü¡A·PÁ°Õ~~~

TOP

¦^´_ 2# yu1234
²Î­pªí-1
Àx¦s®æC3=SUMPRODUCT((Á`ªí!$C$3:$C$20=A3)*(Á`ªí!$D$3:$D$20=B3))
Àx¦s®æD3=SUMPRODUCT((Á`ªí!$C$3:$C$20=A3)*(Á`ªí!$D$3:$D$20=B3)*Á`ªí!$H$3:$H$20)
Àx¦s®æE3=SUMPRODUCT((Á`ªí!$C$3:$C$20=A3)*(Á`ªí!$D$3:$D$20=B3)*Á`ªí!J3:J20)
¦V¥k¡B¦V¤U½Æ»s
²Î­pªí-2
Àx¦s®æC4=SUMPRODUCT((LEFT(Á`ªí!$A$3:$A$20,1)=A4)*(Á`ªí!$H$3:$H$20))
Àx¦s®æD4=SUMPRODUCT((LEFT(Á`ªí!$A$3:$A$20,1)=A4)*(Á`ªí!$J$3:$J$20))
¦V¥k¡B¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# yu1234
Sorry¡I¦Ñªá²´没¬Ý²M·¡
3#¤§²Î­pªí-1Àx¦s®æE3¤½¦¡½Ð­×¥¿¬°
=SUMPRODUCT((Á`ªí!$C$3:$C$20=A3)*(Á`ªí!$D$3:$D$20=B3)*Á`ªí!$J$3:$J$20)

TOP

¦^´_ 4# p212

«D±`·PÁÂP212¤j¤j¨¯­Wªº¸Ñµª¡A
¤½¦¡±a¤J¢±­Ó¤u§@ªí«á¡A³£¯à±o¨ì¥¿½Tªºµª®×©M­pºâµ²ªG¡A
¹ï©ó¤â¤WªºEXCEL»sªí¤u§@¦³«Ü¤jÀ°§U¡A·PÁ°աã¡ã¡ã

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD