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

¤£¦P¬¡­¶Ã¯ ¬Û¦P©m¦W«á­±¼Æ¾Ú¬Û¥[

¤£¦P¬¡­¶Ã¯ ¬Û¦P©m¦W«á­±¼Æ¾Ú¬Û¥[

¥»©«³Ì«á¥Ñ Äå³¥¾¼ ©ó 2011-9-2 17:06 ½s¿è

¦U¦ì¦n¡A§Ú·Q½Ð±Ð¥H¤U°ÝÃD¡G

¤À¬°A¬q¸òB¬q¡A¨â­Ó¬¡­¶Ã¯(¦U§OExcelÀÉ®×)
½Ð°Ý¸Ó¦p¦ó¥Î©m¦W§P§O¡A±N¬Û¦P©m¦W«á­±ªº¼Æ¾Ú¬Û¥[(¬Û¥[µ²ªG¦b'Á~¸ê©ú²Ó'¬¡­¶Ã¯¤º)

¨Ò¦p:
A¬q¤¤ªºB¡@¸ò¡@B¬q¤¤B¡@¥X¶Ô¤u¼Æ¨ºÄæ¬Û¥[ (28.5+8.5=©ú²Ó¤¤¤u¼Æ)
A¬q¤¤ªºC¡@¸ò¡@B¬q¤¤C¡@¥X¶Ô¤u¼Æ¨ºÄæ¬Û¥[ (19.5+6.5=©ú²Ó¤¤¤u¼Æ)
¦Ó¥u¦³¦b¨ä¤¤¤@­Ó¬¡­¶Ã¯¥X²{ªº«h±N¼Æ¾Ú½Æ»s¹L¥h§Y¥i






QQ.rar (31.31 KB)

¦^´_ 1# Äå³¥¾¼

D6=SUMPRODUCT(('[¤ë ¥÷ ­p ¤u ³æ(B¬q).xls]8¤ë'!$A$7:$C$18=$A6)*('[¤ë ¥÷ ­p ¤u ³æ(B¬q).xls]8¤ë'!$AK$7:$AK$18))+SUMPRODUCT(('[¤ë ¥÷ ­p ¤u ³æ(A¬q).xls]8¤ë'!$A$7:$C$18=$A6)*('[¤ë ¥÷ ­p ¤u ³æ(A¬q).xls]8¤ë'!$AK$7:$AK$18))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD