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

±ø¥ó¦¡¥[Á`¦h­ÓÄæ¦ì

±ø¥ó¦¡¥[Á`¦h­ÓÄæ¦ì

¬¡­¶Ã¯1.zip (7.65 KB) ±ø¥ó¦¡¥[Á`,¬O¤£¬O¥u¯à¥[¤@Äæ?¥i¥H²Å¦X±ø¥ó®É,¥[Á`¼Æ­ÓÄæ¦ì?
¨Ò¦p:·íA10:A12²Å¦XA2®É,¥[Á`KÄæ¨ìMÄ檺¼Æ­È

¤@¦~ = 360 ¤Ñ
1-2¦~, À³¸Ó¬O K~NÄæ§a
2-3¦~, O~PÄæ
3¦~¥H¤W QÄæ???

TOP

D2:
=SUM(SUMIF($A$10:$A$12,$A2,OFFSET($J$10:$J$12,,COLUMN(A$1)*3-{2,1,0})))
  ©Î
=SUM(OFFSET($A$9,MATCH($A2,$A$10:$A$12,),COLUMN(A$1)*3+7,,3))

TOP

ÁÂÁª©¥Dªº¯«±Ï´©,ÁÂÁ±z

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD