If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




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? 
Ads 
#2




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? 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Not allowing to continu unless a specific cell has specific answer  madubois9  Excel Discussion (Misc queries)  3  October 25th 07 12:45 AM 
Link to specific cell in specific Excel file  JeroenM  Excel Discussion (Misc queries)  3  July 6th 07 10:08 AM 
Link from a specific Cell in Excel to a specific para. in Word  CathyK  Excel Worksheet Functions  0  August 10th 06 04:40 PM 
Highlight a row if a specific cell is specific numbers/words  sea0221  Excel Worksheet Functions  2  March 9th 05 01:06 AM 
How do I make a cell date specific to input a value on a specific.  ebuzz13  Excel Discussion (Misc queries)  1  January 18th 05 06:53 PM 