- ©«¤l
- 206
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 218
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE 365
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW¥x¥_
- µù¥U®É¶¡
- 2010-5-15
- ³Ì«áµn¿ý
- 2023-6-18
|
¥»©«³Ì«á¥Ñ 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§On¨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©Ô |
|