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? |
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) |