Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need open ended cell for Sum range.
I have numerical data in column A rows 1:14.
I'm adding it up in row 15. Sum=(A1:A14) Now I've been asked to insert more rows with data above row A14. What can I put in my Sum formula in place of A14 so when I insert a new row, any numerical data above it in column A automatically adds up? Sum=(A1:????) I don't want to have to go and change it to sum=(A1:A17) if I insert 3 rows.... I have a huge file to create with sections like this. User may have to insert new rows. They need to all add up. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change a cell range with a reference cell? | Excel Discussion (Misc queries) | |||
How do I refer a Range to a Cell | Excel Worksheet Functions | |||
cell outside range | Excel Discussion (Misc queries) | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
How can I assign a range starting cell based on a variable locati. | Excel Worksheet Functions |