Q: Numbers: Automatically extend ranges to new rows?
Hi,
I have a spreadsheet that I update daily with a new row. I have a bunch of rows at the bottom of the sheet that do various things (e.g. Sum, Countif etc.) on the columns above. Is there a way of getting the range being used to automatically update to include the new row each day?
For example, if I have =SUM($A$1:A2) in cell A4 and I insert a new row in A3 (copying row A2 and pasting formulas), I'd like the sum to update to =SUM($A$1:A3)
Any ideas thankfully recieved!
Posted on Sep 8, 2015 1:42 AM
Hi NotoriousREV,
Have you tried converting your summary rows to footers? I think this will get you what you want as long as your formulas include the last (non-footer) row.
Before I simplified a sheet I had multiple ranges within a single column reporting to different places. I needed to add rows as Kilgore-Trout suggests. I kept an unused row below each range and added rows above them.
quinn
Posted on Sep 16, 2015 4:03 AM