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

[µo°Ý] ¤@­Ó¸òsum ¦³Ãöªº°ÝÃD

[µo°Ý] ¤@­Ó¸òsum ¦³Ãöªº°ÝÃD

­ì¥»§Ú¥Î¤FSUM(A9:A99)¨Ó²Î­p¼Æ¦r.¦ý¥Ñ©ó a99³o³¡¥÷·|ÅÜ°Ê ¨Ò¦p ¤µ¤Ñ¬Oa77 ©ú¤Ñ¤]·|Åܦ¨a105,µM«á¹³³o¼Ëªº²Î­p¶µ¥Ø¤S¦h(¤j¬ù2 ,30­Ó¤£¦P¶µ¥Ø)

§Ú·Q»¡ ¥i¥H¥Î¥N¤Jªº¨Ó¦ýÓý¥¢±Ñ¤F~~SUM("A9:A" & H1) '·Q»¡¥u­n§ïH1ªº¼Æ¦r(¨Ò¦p¿é¤J200)´N¥i¥H²Î­pA9¨ìA200ªº¼Æ¦r..¦ýÓý¤£¦æ. ¬O§Ú¿é¤Jªº¤è¦¡¦³¿ùÁÙ¬O­ì¥»´N¤£¯à³o¼Ë¤F?? ¨º¥i¦æ°µªk¬O«ç§Ë©O??


·P®¦ À°¦£!

¥t¥~¦A½Ð±Ð¥t¤@­Ó°ÝÃD

¦p¤U¹Ï:¬O¤½¦¡¥X¤F¿ù¶Ü?(Vlookupªº)
https://gyazo.com/ca3340c3f46c6c12565cc6bfbe4b472d



Àɮצp¤U: Book1.rar (4.78 KB)

TOP

¦^´_ 2# icestormer


=VLOOKUP(B9,$E$8:$F$11,2,FALSE)

¨ú«á¤@­Ó°Ñ¼Æ, FALSE §¹¥þ¤ñ¹ï

TOP

¦^´_ 1# icestormer

°ÊºA°Ï°ì¥[Á`¡G
=SUM(OFFSET(A9,,,ROW()-9))
©Î
=SUM(INDIRECT("A9:A"&ROW()-1))

TOP

¦^´_  icestormer

°ÊºA°Ï°ì¥[Á`¡G
=SUM(OFFSET(A9,,,ROW()-9))
©Î
=SUM(INDIRECT("A9:A"&ROW()-1))
­ã´£³¡ªL µoªí©ó 2016-8-30 13:43


·P®¦ §Ú¥h¸Õ¸Õ Á¤F!

TOP

¦^´_  icestormer

°ÊºA°Ï°ì¥[Á`¡G
=SUM(OFFSET(A9,,,ROW()-9))
©Î
=SUM(INDIRECT("A9:A"&ROW()-1))
­ã´£³¡ªL µoªí©ó 2016-8-30 13:43



  ³o­Ó§Ú­è¤~¸Õ¤F¤@¤U §Ú§Ñ¤F»¡§Ú·|¥ý¥ÎVBA §P©w¸ê®Æ¬O¨ì¨º¸Ì µM«á(¬O¬Ý¤é´Á§P©w¥X¨Ó) µM«á¥¦·| ¶ñ¤J A199(¦b¬Y¤@®æ¤º) ¨º¦p¦ó§â³oA199±a¤J©O? ¬O­n¥Îsum(indirect³o­Ó¶Ü?)

TOP

¦^´_ 6# icestormer


¤£­nºÞÁ`­p¤½¦¡¦b²Ä´X¦C, ·|¦Û°Ê§ì½d³òªº~

TOP

¦^´_ 7# ­ã´£³¡ªL


   ¤£¦n·N«ä¬O§Ú¨S¦³»¡©ú¥Õ §Ú¦A¸É­Ó¹Ï »¡¤@¤U ·PÁÂ!


https://gyazo.com/2f023f8c3dc164515aa0444fe853b1e4

¦p¤W¹Ï  ¥Ñ©ó¦³®É¶¡ ©Ò¥H§Ú·|¥ý¥ÎVBA §PÂ_¬O¨º¤@¦æ¤~¬O³Ìªñ¤é´Á(2016.08.30) ¦p¹Ï ¬O¦bA120 (©Ò¥HÀx¦s®æA11®æ·|³Q¶ñ¤WA120) §Ú­n«ç§Q¥Î§Aµ¹§ÚªºSUM ¤½¦¡ §âA120±a¤J©O? ¥u²Î­p¨ì A120¬°¤î´N¦n¤F©O?

TOP

¦^´_ 8# icestormer


A120 «ç¨Óªº?
­Y¬O¥Îvba¨ú±oªº¦C¸¹, ¥[Á`ªºÄæ¦ì¬°DÄæ, «h¥i¥Î =SUM(INDIRECT("D9:D"&120))
¬Ý¹êÀɸû²M·¡!

TOP

¥»©«³Ì«á¥Ñ icestormer ©ó 2016-8-30 20:26 ½s¿è

¦^´_ 9# ­ã´£³¡ªL


    ¨º­ÓA120 §Ú¬O¥ÎVBA µ{¦¡ §PÂ_¨ì A120 ¬O2016.8.30(A121Äæ¬O29¤é)  ¨Óªº ¦A¶ñ¤JA11®æ¤º


¥i¥H¤F! ¤Ó·PÁ ¤G¦ìªºÀ°¦£!

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD