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

[µo°Ý] ¦p¦ó§Q¥Î¤½¦¡­pºâ¤u®É

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2012-10-17 13:25 ½s¿è

D3
=SUM(SUMIF(Sheet2!$A:$A,$B3,OFFSET(Sheet2!$C$1:$D$1,,{0,1},,))*{8,1})
E3
=SUM(SUMIF(Sheet2!$A:$A,$B3,OFFSET(Sheet2!$E$1:$F$1,,{0,1},,)))

¥H¤W¬O¥¿½T

****¥X¶Ô¤Ñ¼Æ­n´«ºâ¦¨¤p®É,¥H¨C¤é¤K¤p®É´«ºâ****
¦pªG¼Ó¥D¨S¦³¥H¤W³o¦æ¯S§O­n¨D***,¤½¦¡¤@­Ó´N¥i¥H²³æ³B²z¤F

D3 =SUMPRODUCT((Sheet2!$A$2:$A$7=$B3)*(ISNUMBER(FIND(Sheet2!$C$1:$F$1,D$1)))*Sheet2!$C$2:$F$7)

¥k©Ô¤Î¤U©Ô

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD