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

¤p°ÝÃD½Ð±Ð

¤p°ÝÃD½Ð±Ð

¤p°ÝÃD.rar (7.43 KB)

Dear¦U¦ì¤j¤j¡G

¤£§÷ªº§Ú¤S¨Óµo°Ý¡A¤£¹L«Ü³ßÅw½×¾Âªº¹ªÀy¼Ð»y¡A¡yµo°Ý¬O¶i¨Bªº°Ê¤O¡z¡A§Æ±æ¦Û¤v¥i¥H¦hµo°Ý¦h½m²ß¡A¦pªþÀÉ¡C

    ¦A·Ð½Ð«ü±Ð¡C¤]§Æ±æ´£¨Ñ§ó¦h¤£¦P¤èªk°Ñ¦Ò»P°Q½×¡C

°ÝÃD²­z¡Gsearch¬ì¥Ø¬Û¦P¡A¦ý¤À¼Æ¤£¦P¤§­È¡A§@¥­§¡¡CÁÂÁÂ

·s¤B¥u²¤À´¥Ö¤ò¡A¬Ý¬Ý¬O§_¦X¥Î¡I
B13=SUMIF(A3:A9,A3,B3:B9)/COUNTIF(A3:A9,A3)
­Y¦³¿ùº|¡A¸U¤Å¨£¨õ¡I

TOP

¦^´_ 2# trainee


    Dear¤j¤j¡G
   ÁÂÁ¦^ÂСA¥t¥~¦³·Q¨ìB13=SUM(($A$3:$A$9=$A13)*(C$3:C$9))/SUM(($A$3:$A$9=$A13)*((C$3:C$9<>""))*1)
¤£¹LÁÙ¬O¤j¤jªº¤½¦¡Â²³æ¡A§Ú§â¥¦½ÆÂø¤Æ¤F¡A¦A¦¸ÁÂÁ«ü±Ð¡C

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD