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

[µo°Ý] =SUM(!XFC24:!D24) ³o¼Ë¥Îªk¤°麽±¡ªp®É·|¥X°ÝÃD?

[µo°Ý] =SUM(!XFC24:!D24) ³o¼Ë¥Îªk¤°麽±¡ªp®É·|¥X°ÝÃD?

=SUM(!XFC24:!D24) ³o¼Ë¥Îªk¤°麽±¡ªp®É·|¥X°ÝÃD?

¥H«e¥Î¹L¥Î "!"¨Ó©R¦W¦WºÙ,«á¨Ó¦]¬°°¸µM·|¥X¿ù´N¤£¥Î,§ï¥Î indirect,¦p¤U:
©R¦W A=!A100  >>>>>>>>>>>>A=indirect("a100")
§Ú²M·¡¥Î ! ¾a¤£¦í,¦ý¥Ø«e§Ú­n©w¸qªº¦WºÙ¤S¤£ª¾¦p¦ó¼g,©Ò¥H¦³¥Îªð !
¦WºÙ hSum=sum(!xf24:!D24), hSum¥Î¤F2¤Ñ,´X¤d¦¸,°ß¤@µo²{ªº°ÝÃD¬O,¤£¯à§Y®Écalculate,§Ú¥[¤F¥y calculatefull,´N¯à§Y®É­pºâ¤F
©Ò¥H§Ú²{¦b·Q½Ð±Ð¬O ©ÎªÌ¤W­z¦WºÙ¦p¦ó¥Îindirect©R¦W ©ÎªÌ¬O¤£¬O¥i¥H§i¶D§Ú¥Î"!"¦MÀI¦b­þ¸Ì,ÁÂÁ«üÂI
lmh

¦^´_ 1# mhl9mhl9
¤£¯à§Y®Écalculate ??? ¥iªþÀɬݬÝ??
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

Try3.rar (113.39 KB) ¦^´_ 2# GBKEE


ªþ¥ó¦³2±isheet,¥Î¦P¼Ëªº¤½¦¡,open¤å¥ó,first sheet­pºâ·Ç½T,second sheet¨S¦³­pºâ,application.calculatefull´Nok¤F.
¤£¯à§Y®É­pºâ¦³¦h­«±¡§Î¤U·|µo¥Í,¦ý§Ú¤£±o­n»â,©Ò¥Hµo°Ý¨D±Ï,²{¦b¥ÎcalculatefullÀ³¥Iuser,ÁÂÁÂÀ°¤â.
lmh

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2013-9-15 14:43 ½s¿è

¦^´_ 3# mhl9mhl9
2003ª© ¨S§A»¡ªº°ÝÃD.§Ú¨S¦³¥Î, Application.Calculatefull´Nok
[2014monthly]ªºFø󤽦¡= hSum ,hSum=SUM(!RC[-6]:!RC[-1],) ¦p F7 =hSum:  =SUM(!E7:!I7)
ªþÀɶ}±Ò«á [2014monthly]¤¤¬Ý¨ìEøó:Iøó ¨S¼Æ­È,§Ú¦bE7:I7¶¡¿é¤J¼Æ¦r,hSum¥ß§Y­pºâ¥X¼Æ­È(¦p¹Ï)


·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 4# GBKEE


    2014monthly¤¤¨S¦³¸ê®Æ,©Ò¦³formulaµ²ªG¬O0,¦ý²{¦b¤£¬O0,¦]¬°"!"¤½¦¡¤£¯à¦Û°Ê­pºâ,¥´¶}¤å¥ó¿ï¾Ü2014monthly,¨£¨ì¤£¤Ö¿ù»~ªºµ²ªG,«öcontrol+alt+f9,¤½¦¡Åã¥Ü¥¿½Tµ²ªG0.
¦pªG¤£¥Î"!"¦b¤½¦¡¨½,ª½±µ¥Î"2014monthly!"¥N´À"!",´N¤£·|µo¥Í³oºØ±¡ªp,Ãþ¦ü¥X¿ù±¡ªpÁÙ¦³¤£¤Ö,¦p¥Îvb§Û¤À¤½¥qªº¸ê®Æ¨ì³o­Ó¤å¥ó,³o¨Ç¤½¦¡¦³ªº­pºâ¦³ªº¤£ºâ(§Ú²{¦b¥Îcalculatefull¸Ñ¨M,³q±`¥u¬O«öf9³£¤£¦æ),³o¨Ç±¡ªpÅýuser¨£¨ì¤£¬O¤j·Ù­·´º,§Ú¥Ø«e¤£¬Ocalculatefull´N¬O sendkey "^%{f9}",¨ì¤]¥i¥HÀ³¥I¹L¥h(¨S¦³·N¥~,¨S¦³Ãø¬ÝªºÅã¥Ü)

©Î³\§A·|Á¿,¬JµMº|¬}³o»ò¤j,爲¤°麽ÁÙ¥Î?°ÝÃD¤£¦b§Ú¥i¥H¼g¤Ö´X­Ó"¦WºÙ"(,100±isheet,­n¼g500­Ó¦WºÙ),§Úı±oÄY­«ªº¬Ouser¨£¨ì·|ÀY¯k,¥H«áºû­×¤]³Â·Ð.
¥Î"!"¥i¥H§â¦¨¤d¤W¸U¤½¦¡Åܬ°5­Ó­^¤å¦r¦ê,¥´ª½¥[=vSum,¥´¾î¥[=hSum,¸õ®æ¥[=iToyal,2013¦~¥[Á`=2013Total.......³o¼Ë°µ,µL½×§Ú°µfile,user¥Îfile,user¦Û¨­ºû­×,¥H«áºû­×³£¤è«K¤£¤Ö.
§A¥i¥H¦P·N§Úªº·Qªk¶Ü?

§Ú°O±o¦³ºô¤Íĵ§i¹L,¤£­n³o¼Ë¥Î"!",¬Ý¤F¤]§Ñ¤F爲¤°麽,©Ò¥H¦b³o¨àµo°Ý,§Æ±æ¦U¦ì°ª¤â´£´£¬Ýªk.

ÁÂÁÂÃö¤Á§Úªºµo°Ý
lmh

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2013-9-16 06:20 ½s¿è

¦^´_ 5# mhl9mhl9
¨S¦³º|¬}.

   
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 6# GBKEE


    §Ú¤âÃä¨S¦³2003,¤£¯à¸Õ,ªþ2¹Ï¤ù,¨ä¤@¬O¥´¶}¤å¥ó2014monthly¤£À³¦³¼Æ¾Ú,¦ýÅã¥Ü¤F2013monthlyªº¼Æ¾Ú,¨ä¤G¬O§Ú¿é¤J123456,¥u¦³¤@­Ó¤½¦¡¥¿½T,¿ù»~ªº¼Æ¾ÚÁÙ¬OÅã¥Ü¥X¨Ó.
lmh

TOP

¦^´_ 6# GBKEE


    §Ú¦b§Aªº¹Ï¤ù¨½¤]¨£¨ì"27020","1475"......³o¨Ç¼Æ¾Ú¬O2013monthlyªº,2014monthlyÀ³¸Ó¬O0.
©Ò¥H§Ú¬Ý,2003©M2007¤@¼Ë¬O¿ùªº
lmh

TOP

¦^´_ 8# mhl9mhl9
¦WºÙ©w¸q =SUM(!E7,!E11 ,!E15 ....)³o¤£³sÄòªºÀx¦s®æ,­n¦h¤@¹D¤âÄò

   
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD