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? |
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? |
All times are GMT +1. The time now is 04:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com