¦WºÙ©w¸q
R_R=INDIRECT("R"&ROW())
T_3=INDIRECT("R3C"&COLUMN(),0)
T_5=INDIRECT("R5C"&COLUMN(),0)
X=R_R+T_3
Y=T_5-R_R
»¡©ú¡J
Sheet1!
T7
=IF(OR($R7="",T$5="",$R7>=T$5,T$5-$R7=$R7+T$3),"",IF(AND(SUMIF(OFFSET($J$6,IF({1;0},X,Y),,,7),OFFSET($I$6,$R7,MATCH($R$5,OFFSET($J$6,T$5,,,7),)))),Y,""))
§Y·íT5´Á¼ÆªºR5È(EX¡JT5=41=M47=30)¡A
¨ä¦bR7´Á¼Æªº¦PÄæ¹ïÀ³È(EX¡JR8=2=M8=29)¡A
¦³¦AÅã¥Ü©ó«ü©wªºX(EX¡JR8+T$3=111=L117=29)¡AY(EX¡JT$5-R8=39=P45=29)®É¡A
«hT7Åã¥ÜYÈ(EX¡JT8=39)¡A§_«hÅã¥ÜªÅ¥Õ¡C
¨ä¾lT12,T32,T41¥H¦¹Ãþ±À¡C
»Ý¨D¡J
·Q±N~
·íT5´Á¼ÆªºR5È¡A¨ä¦bR7´Á¼Æªº¦PÄæ¹ïÀ³È¦³¦AÅã¥Ü©óX,Y¤G¦C~
§ï¬°~
·íT5´Á¼ÆªºR5È¡A¨ä¦bR7´Á¼Æ¤§¦PÄæ¹ïÀ³È¦³¦AÅã¥Ü©ó«ü©wX,Y¤G¦Cªº¡y¦PÄæ¦ì¡z¡C
¸Ô¦pSheet2!T41
PS¡J¤p§Ì¥u·|¥ÎCOUNTIF¡A¦ý®Ä²v¤£¨Î^^"
¥H¤W Àµ½Ð¦U¦ì«e½ú¡B¥ý¶i¤£§[½ç±Ð! ÁÂÁÂ!
°Ñ¦Òªþ¥ó¡J
http://www.FunP.Net/502777 |