Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm new to VBA Excel and need some help creating some code.
I want to sum two columns of data; the number of rows with data is variable. First sum=: cell F10 through the end of the range (Which I would normally select by using shift/ctrl/down arrow). The Sum of this range needs to be in cell G2. Second Sum: The second sum needs to be the total of the range that starts 3 rows below (i.e. 2 blank rows) through the end of the data in that column (Again, I use shift/ctrl/down arrow). This sum needs to be in cell G6. Am having a tough time writing the code correctly to select the two ranges....thanks for any hints you can provide. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
Question on Named range with formula | Excel Worksheet Functions | |||
formula for range values question | Excel Discussion (Misc queries) | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
Range.Formula and Range question using Excel Automation | Excel Programming |