¹ØÓÚSUM(R[-11]C:R[-1]C)µÄÎÊÌâ
Çë¸÷λ´óÏÀÏêϸ½²½âÒ»ÏÂÔÚVBAÖÐSUM(R[-11]C:R[-1]C)µÄ¾ßÌ庬ÒåºÍÓ÷¨£¬ÎÒÏë°ÑÀïÃæµÄ11»»³É±äÁ¿Ôõô°ì£¿
ÇóÒ»¸ö·¶Î§ÖеÄÊý¾ÝµÄºÍ,µ«ÕâÀïÃæµÄÕâ¸ö·¶Î§R[-11]C:R[-1]C...,µÚ1ÐÐCÁÐÖÁÿ11ÐÐCÁÐ?
ûÕâÑùÓùý...
¸Õ²éÁËÒ»ÏÂ:ÕâÊÇÒ»ÖÖ¹«Ê½ÊäÈëµÄÑùʽ,³ÆΪFormulaR1C1¹«Ê½ÊäÈë·½·¨
ÈçÌâÖеÄSUM(R[-11]C:R[-1]C)ÕâÑùµÄд·¨¾ÍÊÇFormulaR1C1¹«Ê½ÊäÈë·½·¨
ÓÐÖÐÀ¨ºÅÊÇÏà¶ÔÓÚÑ¡¶¨µ¥Ôª¸ñµÄÏà¶ÔÆ«ÒÆÁ¿£¬"-"ΪÏò×ó»òÏòÉÏÆ«ÒÆ£¬ÕýÊýΪÓÒ»òÏÂÆ«ÒÆ¡£
ÎÞÖÐÀ¨ºÅΪÏà¶ÔÓÚÑ¡¶¨µ¥Ôª¸ñµÄ¾ø¶ÔÆ«ÒÆÁ¿£¬Ã»ÓиºÊý
"R"ºÍ"C"´ý±ä¡°ÐС±ºÍ¡°ÁС±
È磺ѡ¶¨µ¥Ôª¸ñΪD20ÖÐÊäÈëSUM(R[-11]C:R[-1]C):
R[-11]CΪD9,R[-1]CΪD19
SUM(R[-11]C:R[-1]C):¾ÍÊǶÔD9:D19µÄµ¥Ôª¸ñÇøÓòÇóºÍ
°ï¶¥
"SUM(R[-" & YourV & "]C:R[-1]C)"
Ïà¹ØÎÊ´ð£º
QQȺ 29152388
ÓÑÇéUP
°ï¶¥
up
°ïup
up Ö§³Ö£¡
up jf
...ÄѵÀÓзÖ..?
up up up
Ï£ÍûÓеüӷ֣¬¹þ¹þ¡£
Ö§³Ö£¬ÎÒ¼ÓÁË£¬Ï£ÍûÂ¥Ö÷ÄܼÓÎÒ£¬¹²Í¬Ñ§Ï°¹þ
¼ÓÁË¡£
¶¥ÉÏ£¬Ã¿ÌìÊÕ»ñÒ»µã£¬Ö§³Ö ......
±àÒëÆÕͨµÄcûÎÊÌâ°¡£¬µ«±àÒëjavahÉú³ÉµÄ¾Í±¨´í£º
gcc -O0 -g3 -Wall -c -fmessage-length=0 -oHelloWorld.o ..\HelloWorld.c
gcc -otest.exe HelloWorld.o
d:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../. ......
CÅÌ9G£¬ËãÁËһϸ÷ÖÖÎļþ°üÀ¨ÒþÐÎ×ܹ²²»µ½2G£¬¿ÉÊÇϵͳÏÔʾֻʣÓà1¸ö¶àG£¬ÎÒÒѾ½«¸÷ÖÖÁÙʱÎļþ¶¼É¾³ýÁË£¬°üÀ¨´ÅÅÌÇåÀí£¬Ôõô»ØÊ£¿Ð»Ð»»Ø´ð
ʲôϵͳ£¿
ÐéÄâÄÚ´æÉèÖõ½ÆäËüÅÌ£»
¹Ø±Õϵͳ»¹Ô£»
ɾ³ýÐ ......
µØµãÔÚÉîÛÚÄÏɽ
¡¡¡¡×öCÈí¼þ¡£ÊÔÓÃ2K£¬²»ÖªµÀתÕý¸ø¹«Ë¾Ì¸¶àÉÙºÏÊÊ°¡£¿
¡¡¡¡ÁíÍ⣬±¾ÈËС±¾£¬Ó¢ÓïÁù¼¶£¬ÊÔÓÃÈý¸öÔ±íÏÖµÃÒ²ËãÖÐÉÏˮƽ¡£µ«ÊÇÏÖÔÚ»¹²»ÄÜ×öÏîÄ¿¡£ÁíÍâ±ÏҵѧУûÓÐÃûÆø¡£
¡¡¡¡×ªÕý¸ø¹«Ë¾Ì¸¶àÉ ......
ÎÒ¸öÈ˸оõÓеĵط½Ã»±ØÒª¿´£¬·±ËöµÃºÝ£¬ÓÃ×Ô¼º×ܽáµÄ·½·¨¸üºÃ£¬´ó¼Ò˵˵×Ô¼ºµÄÒâ¼û
ÎҸоõ±ã½Ý¼ÆËãÓë²»¶Ô³Æ±ß½çÍêÈ«¸ù¾Ý×Ô¼ºµÄ¾ÑéÀ´£¬Óò»×Å¿´Å¶£¬´ó¼Ò˵˵
Äã¿´²»¿´ÄÇÊÇÄãµÄÊÂ
Æäʵ¶¼ÊÇ»ù´¡µÄ¶«Î÷À²
......