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

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

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

¦U¦ì¦n

½Ð°Ý¦pªþ¥ó ¦p¦ó§Q¥Î¤½¦¡­pºâ¤u®É

ÁÂÁÂ

´«ºâ¤u®É.zip (6.75 KB)

d3=VLOOKUP(B3,Sheet2!$A$2:$F$7,3,)*8+VLOOKUP(B3,Sheet2!$A$2:$F$7,4,)
e3=VLOOKUP(B3,Sheet2!$A$2:$F$7,5,)+VLOOKUP(B3,Sheet2!$A$2:$F$7,6,)

TOP

¦^´_ 2# ANGELA


    ¦]¬°·|¦³½ü½Õ³¡ªù¦bsheet2¦P¤@¤H·|¦³¤Gµ§¸ê®Æ,¥Îvlookup·|º|¥[¥t¤@µ§¸ê®Æ

    ½Ð°Ý¬O§_¥t¦³¸Ñ¨M¤èªk?

      ÁÂÁÂ

TOP

d3=SUMIF(Sheet2!$A$2:$A$8,Sheet1!B3,Sheet2!$C$2:$C$9)*8+SUMIF(Sheet2!$A$2:$A$8,Sheet1!B3,Sheet2!$D$2:$D$8)

e3=SUMIF(Sheet2!$A$2:$A$8,Sheet1!B3,Sheet2!$E$2:$E$8)+SUMIF(Sheet2!$A$2:$A$8,Sheet1!B3,Sheet2!$F$2:$F$8)

TOP

¥»©«³Ì«á¥Ñ 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 : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD