Formulas on iPad Pro don't update when adding new rows
How can I keep my existing formulas when I add a new row on my iPad Pro?
I had three rows and then added another one. You can see the formula doesn’t carry down onto the new row.
iPad Pro
Question marked as
It will not include rows added outside of the range in the formula; it will not increase the range to include them. If you add rows in the middle (like at row 2), they will be included. Or you can use the "whole" column reference instead and it will include all rows, new and old. That is the best way.
=SUM(R)