Remember Me?

#1
July 9th 08, 12:49 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2008 Posts: 8
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?

#2
July 9th 08, 01:57 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 72
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(99999999999999999999999 9999999,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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post madubois9 Excel Discussion (Misc queries) 3 October 25th 07 12:45 AM JeroenM Excel Discussion (Misc queries) 3 July 6th 07 10:08 AM CathyK Excel Worksheet Functions 0 August 10th 06 04:40 PM sea0221 Excel Worksheet Functions 2 March 9th 05 01:06 AM ebuzz13 Excel Discussion (Misc queries) 1 January 18th 05 06:53 PM

All times are GMT +1. The time now is 11:13 PM.