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

[µo°Ý] §PÂ_±ø¥ó°ÝÃD½Ð±Ð

[µo°Ý] §PÂ_±ø¥ó°ÝÃD½Ð±Ð


¦p¦óÅý¤u®ÉCÄæ§PÂ_BÄ涵¥Ø¡A¦A¨Ì·ÓAÄæ»sµ{±a¥X­Ó§O¤u®É?
¸ê®Æ®w¤À­¶.png

§x´o¾ã¤U¤È¼g¤£¥X¡A½Ð¨D¦U¦ì¨ó§U
·P¿E¤£ºÉ ÁÂÁÂ

http://blog.xuite.net/hcm19522/twblog/417647802

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2016-5-30 10:58 ½s¿è

¦^´_ 1# pk0116
°²³]¸ê®Æ¦ì©ó¬Û¦P¤@­Ó¤u§@ªí (¤u§@ªí1)
1.©w¸q¦WºÙ¡u¶µ¥Ø¡v (»s§@°ÊºA½d³ò¡A¶µ¥Ø·s¼W®É¤£¥Î§ï¤½¦¡¡C)
¡u°Ñ·Ó¨ì¡v¿é¤J
=OFFSET(¤u§@ªí1!$F$3,,,COUNTA(¤u§@ªí1!$F:$F)-1)
2.Àx¦s®æD3¿é¤J
=IF($B3="",SUM(OFFSET($F$2,MATCH($C3,¶µ¥Ø,0),1,,2)),OFFSET($F$2,MATCH($C3,¶µ¥Ø,0),$B3))
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I

FIG.jpg (40.3 KB)

FIG.jpg

TOP

¦^´_ 1# pk0116
¹Ï¤¤¤Wªí¦b Sheet1
¹Ï¤¤¤Uªí¦b Sheet2

Sheet1.C2 =SUMPRODUCT(SUMIF(Sheet2!A:A,B2,OFFSET(Sheet2!B:B,,{0,1}))*IF(A2="",{1,1},{1,2}=A2))
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¤Ó·PÁ¦U¦ì¨ó§U¤F

¦hÁ«¤j®aªºÀ°¦£ °ÝÃD¤w¸g¸Ñ¨M¤F

ÁÂÁ¦U¦ì

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD