Sum below a specific row   

I am attempting to use the SUM function to add values below a certain row? I 
know that SUM(A:A) can be used to add every value in the column, and 
SUM(A1:A5) can be used to add values in a defined range.

What do I do if I only know one of the values in my range?  For example, I'd 
like to be able to add the values in column A for every row below row 8 
without having to change the defined range each time. e.g - SUM(A9:A??)

How can this be accomplished?

date: Tue, 8 Jul 2008 16:49:02 -0700   author:   jdunnisher

RE: Sum below a specific row   

Hi jdunnisher,

You can sum all numbers below row 8, 

SUM(A9:A1048576)

because Excel 2007 has a 1,048,576 row capacity,

or

If all of the cells between the first cell and the last cell have a value, 
and there is always a blank after the last cell to be summed:

=SUM(INDIRECT("A9:A"&MATCH(999999999999999999999999999999,A:A,1)))

In place of the 999..., use a number that will always be greater than any 
number being summed. 

Thanks,
Peggy


"jdunnisher" wrote:

> I am attempting to use the SUM function to add values below a certain row? I 
> know that SUM(A:A) can be used to add every value in the column, and 
> SUM(A1:A5) can be used to add values in a defined range.
> 
> What do I do if I only know one of the values in my range?  For example, I'd 
> like to be able to add the values in column A for every row below row 8 
> without having to change the defined range each time. e.g - SUM(A9:A??)
> 
> How can this be accomplished?

date: Tue, 8 Jul 2008 17:57:01 -0700   author:   pshepard