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.
When I add a row with various descriptors and a value in the next to last column, how do I get the last column to automatically increment the total value? I'm using the SUM col1:collast. But, I have to update it manually every time to have it display the total.
iMac 27″ 5K, macOS 13.6
Hi Michael,
A table with a Header Row and a Footer Row.
Formula in Footer is SUM(B)
The formula sums all Body cells but ignores Header and Footer cells (otherwise there would be a "self reference" error).
The formula automatically expands when new rows are added.
Regards,
Ian.
michaelfromapex wrote:
Another way would be for each new row Sum C up to this point.
Hi Michael,
Good catch!
If I understand your reply, try this
Formula in C1 is SUM(B$1:B1)
Fill Down.
Add another row at the bottom and enter the new value in B:
The formula automatically fills down.
To answer your question about Header and Footer rows, you don't need them using this method. But yes, They are special (not simply the first and last rows).
When you need then, create them here:
Or here:
Regards,
Ian.
Thx for the reply, but I'm afraid I'm more confused. Do the terms header and footer denote special rows that I have not specified? Or, are they just the first and last row? I'm keeping a running total. C2 should show SUM B1:B2. C3 is SUM B2:B3 etc. When I add a row and enter a value in B the formula in C should be the new total. Another way would be for each new row Sum C up to this point. But, what will happen to the previous cells in C when I add a new row?
Thanx, Ian! That is what I am looking for! Thanx for taking the time to decipher clumsy description.
Regards,
Mike
Hi Mike,
Thanks for your feedback. That may help other users. Keep posting in Apple Support Communities.
Regards,
Ian
Automatically increment formula when adding a row
