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 have a column which I am adding numeric amounts to and I want the next column to be the total of these amounts as I add them. Could anybody offer any advice as to how I can do this?
For example I may have in the first column 25, 10, 300, 2000 and in the next column I would like to add a formula that totals these items as I add them, so 25, 35, 335, 2335 etc
Many thanks,
Martin
You can do something like this:
The formula in B2, filled down the column:
=SUM(A$2:A2)
Enter the formula in B2. Click B2, hover over the bottom edge of the cell, and drag the yellow dot down.
This creates an "expanding range" whose top cell is anchored by the $ to the second row and last cell changes to reflect the row the formula is on.
SG
You can do something like this:
The formula in B2, filled down the column:
=SUM(A$2:A2)
Enter the formula in B2. Click B2, hover over the bottom edge of the cell, and drag the yellow dot down.
This creates an "expanding range" whose top cell is anchored by the $ to the second row and last cell changes to reflect the row the formula is on.
SG
Thank you very much SGlll, this worked perfectly!
martsm
Total of items in one column in the next column
