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

[µo°Ý] ½Ð±Ð¦p¦ó°w¹ï¯S©w¸ê®Æ¥[Á`?

[µo°Ý] ½Ð±Ð¦p¦ó°w¹ï¯S©w¸ê®Æ¥[Á`?

½Ð°Ý¦U¦ì°ª¤â~

°Ñ·Óªþ¥ó--
±N¨C¤Ñªº§@·~¤é»x¤¤³B²z¤H­û©Ò³B²zªº§@·~,§@·~¤À¯Å¥[Á`,¦ýÅã¥Ü"­«¤u"¤£¨º¤J¥[Á`¸Ì­±;¨ä¥[Á`Åã¥Ü¦b"§@·~¤ñ¨Ò"¤¤!
¦³¤°»ò¿ìªk¥i¥H¸Ñ¨M©O?

³Â·Ð¤F ÁÂÁÂ~

°Ñ¦Ò¸ê®Æ.zip (16.08 KB)

¦^´_ 1# like026
§@·~¤ñ¨Ò¤u§@ªí¤§Àx¦s®æB2 =SUMPRODUCT(('§@·~¤é»x-1'!$D$8:$D$19=$A2)*('§@·~¤é»x-1'!$L$8:$L$19))
§@·~¤ñ¨Ò¤u§@ªí¤§Àx¦s®æC2 =SUMPRODUCT(('§@·~¤é»x-2'!$D$8:$D$19=$A2)*('§@·~¤é»x-2'!$L$8:$L$19))
°é¿ïÀx¦s®æB2»PC2¡A¦V¤U½Æ»s¤½¦¡¡C
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# p212

·PÁ§Aªº¦^ÂÐ~~

¦ý¬O¦pªG§@·~¤é»x¤¤¹J¨ì"­«¤u" ¦r¼Ë«h¨º¦æ´N¤£­n¥[¤W§@·~µ¥¯Å©O?
¦³¤ñ¸û²³æªº¤è¦¡¶Ü?

¦pªG¤£¦æªº¸Ü¨º§Ú´Nª½±µ§â­«¤u¨º¦æªº§@·~µ¥¯Å¥Î¤H¤u§R°£~
¶W¯Å·PÁ³á³á : )

TOP

¦^´_ 3# like026


    ©Ó¤W ¦p¥h±¼­«¤u¨º¦æ¤£¥[Á`ªº¸Ü´N·|Åܦ¨

Nancy        2
Nicole        15
Jack        0

TOP

¥»©«³Ì«á¥Ñ aer ©ó 2014-4-16 14:11 ½s¿è

¦^´_ 1# like026
¸Õ¸Õ¬Ý,§@·~¤ñ¨Ò¤u§@ªí¿é¤J¤U¦C¤½¦¡

B2=SUMIFS('§@·~¤é»x-1'!$L$8:$L$16,'§@·~¤é»x-1'!$D$8:$D$16,§@·~¤ñ¨Ò!$A2,'§@·~¤é»x-1'!$H$8:$H$16,"<>­«¤u")
C2=SUMIFS('§@·~¤é»x-2'!$L$8:$L$16,'§@·~¤é»x-2'!$D$8:$D$16,§@·~¤ñ¨Ò!$A2,'§@·~¤é»x-2'!$H$8:$H$16,"<>­«¤u")

¿ï¨úB2»PC2 ¦V¤U½Æ»s

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-4-16 14:12 ½s¿è

¦^´_ 4# like026
Sorry! º|±¼¤F¡u­«¤u¡v¦]¯À¡I
§@·~¤ñ¨Ò¤u§@ªí¤§Àx¦s®æB2
=SUMPRODUCT(('§@·~¤é»x-1'!$D$8:$D$19=$A2)*('§@·~¤é»x-1'!$L$8:$L$19)*('§@·~¤é»x-1'!$H$8:$H$19<>"­«¤u"))
§@·~¤ñ¨Ò¤u§@ªí¤§Àx¦s®æC2
=SUMPRODUCT(('§@·~¤é»x-2'!$D$8:$D$19=$A2)*('§@·~¤é»x-2'!$L$8:$L$19)*('§@·~¤é»x-2'!$H$8:$H$19<>"­«¤u"))

TOP

¦¨¥\¤F!!¶W¯ÅÁÂÁ¨â¦ì~~~: )

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD