Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not allowing to continu unless a specific cell has specific answer | Excel Discussion (Misc queries) | |||
Link to specific cell in specific Excel file | Excel Discussion (Misc queries) | |||
Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) |