You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hi.
I would like to gather the sum of a column of numbers (larger table) and have that sum auto update in the smaller table as I add rows to the larger table. Once I add the row to larger table I will drag down the formula above it to get new figures, but I need the smaller table to auto update.
MacBook Pro 13", macOS 10.15
Not sure which column in the big table you want to sum. In any case it's easy:
Because you have selected the entire column that formula will automatically include any new rows you add to the big table.
SG
Not sure which column in the big table you want to sum. In any case it's easy:
Because you have selected the entire column that formula will automatically include any new rows you add to the big table.
SG
Hi Matt,
If you want your SUM in the larger table too you can convert the last row to a footer row and put SUM in there. Follow SG's instructions and your SUM will stay in that last row as you add rows to the table.
quinn
Thank you SG! That was easy.
Sum of column.
