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

½Ð°Ý±q³\¦h­Ó¼Æ¾Ú¾ÜÀu¨Ã¥[Á`ªº¼gªk

½Ð°Ý±q³\¦h­Ó¼Æ¾Ú¾ÜÀu¨Ã¥[Á`ªº¼gªk

¥þ¯Z­YÁ`¦@°µ¤F20¦¸ªº´úÅç,
­nºâ¥X¨C­Ó¤H³Ì¦n¤»¦¸ªºÁ`¤À
³Ì¤è«Kªº¼gªk¬O¬Æ»ò©O?
·s¤â¾Çexcel

¨º­n¬Ý§Aªº¸ê®Æµ²ºc±Æ¦C¤è¦¡¨Ó¿ï¾Ü³Ì¾A¦Xªº¤èªk¡C

TOP

¦^´_ 2# oobird

Á`¤H¼Æ¬ù360¤H¡A´úÅ禸¼Æ20¦¸
­n¾ÜÀu­Ó¤H³Ì¦nªº¤»¦¸
±Æ¦C¨Ì¦¸¼Æ
·s¤â¾Çexcel

TOP

°²³]¦¨ÁZ¦ba1:t1
°}¦C¤½¦¡
{=sum(large(a1:t1,{1,2,3,4,5,6}))}
joviwang

TOP

¦^´_ 4# joviwang


·PÁ¡Aexcel¯uªº¦n¦n¥Î¡I
§Ú­n¦h¥[ªo¡I¡I

¦A½Ð°Ý¦pªG§Ú­n¦b20¦¸¦Ò¸Õ¤¤
¨C¤­¦¸¾ÜÀu2¦¸¡A¨Ã¥[Á`
¤]´N¬O»¡±q1~5¡B6~10¡B11~15¡B16~20¥|²Õ¤¤
¦U¾ÜÀu¨â¦¸¡AÁ`¦@8¦¸¡A¨Ã§â³o8¦¸¥[°_¨Ó
§Ú¥²¶·¤À¥|¦¸¥hºâ¦A¥[Á`¶Ü¡H¡]¥Î¤W­±ªº¦¡¤l¡^
ÁÙ¬O¥i¥H¥ÎÃþ¦üªº¼gªk¡A¤@¦¸§¹¦¨©O¡H
·s¤â¾Çexcel

TOP

¦^´_ 4# joviwang

¤ñ¤è»¡
{=sum(large(a1:e1,{1,2}))+sum(large(f1:j1,{1,2}))+sum(large(k11,{1,2}))+sum(large(p1:t1,{1,2}))}
·s¤â¾Çexcel

TOP

        ÀR«ä¦Û¦b : ¸Ü¦h¤£¦p¸Ü¤Ö¡A¸Ü¤Ö¤£¦p¸Ü¦n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD