Newsroom Update
The redesigned iPad Air and new iPad Pro with Apple silicon are now available. Learn more >
The redesigned iPad Air and new iPad Pro with Apple silicon are now available. Learn more >
I keep my home accounts using a numbers spreadsheet - the last column is a formula showing the running total. However, when I sort the information by date the formula does not stay pointing at the cell above. It seems to keep the cell reference where it came from and no longer references the pertinent values. Is there a way to keep the formulas intact when I sort by date?
I recommend review of the Numbers User Guide for iPad - as this may hold answers to many usage queries. The Guide is available both as an online resource and as a download for Apple Books:
Numbers User Guide for iPad - Apple Support
https://books.apple.com/gb/book/numbers-user-guide-for-ipad/id1450570987
Here is another useful resource:
Numbers - Function list - Apple (UK)
I recommend review of the Numbers User Guide for iPad - as this may hold answers to many usage queries. The Guide is available both as an online resource and as a download for Apple Books:
Numbers User Guide for iPad - Apple Support
https://books.apple.com/gb/book/numbers-user-guide-for-ipad/id1450570987
Here is another useful resource:
Numbers - Function list - Apple (UK)
Numbers. How to get the value in a cell
