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

[µo°Ý] ¨â­Ó°Ñ¦Ò«á¥[Á`

[µo°Ý] ¨â­Ó°Ñ¦Ò«á¥[Á`



¬¡­¶Ã¯1.rar (7.34 KB)
sky

¥»©«³Ì«á¥Ñ p212 ©ó 2013-8-3 21:24 ½s¿è

¦^´_ 1# qwer7632
´N±z´£¨Ñªº½d¨Ò¸ÑÃD¡A½Ð°Ñ¦Ò¡I
1¡BÀx¦s®æH2¿é¤J¤½¦¡
=SUMIFS($D$2:$D$6,$B$2:$B$6,F2,$C$2:$C$6,G2)
¦V¤U½Æ»s¤½¦¡
2¡BÀx¦s®æH10¿é¤J¤½¦¡
=SUMIF($B$10:$D$14,F10,$D$10:$D$14)
¦V¤U½Æ»s¤½¦¡

TOP

¦^´_ 2# p212


   ÁÂÁ¦³¾Ç¨ì¤F
sky

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD