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.
📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
WHat would the formula be to calculate the sum of a column of numbers minus the last entry of the column? The position of the last number in the column will change occasionally.
MacBook Pro (13-inch, Late 2016, 4 TBT3), macOS High Sierra (10.13.3)
Bruce Kieffer wrote:
In other words, it needs to be for say H42:H50. I will try modifying your formula. My formula cell is one column to the right of the column with the series of numbers.
Then you can try something like this:
=SUM(OFFSET($A$41,0,0,COUNTA(A42:A50),1))
The only difference is that the "anchor" cell (the first argument) is changed from $A$1 to $A$41 and instead of referring to the whole column within COUNTA you refer to your A42:A50 range.
SG
Bruce Kieffer wrote:
In other words, it needs to be for say H42:H50. I will try modifying your formula. My formula cell is one column to the right of the column with the series of numbers.
Then you can try something like this:
=SUM(OFFSET($A$41,0,0,COUNTA(A42:A50),1))
The only difference is that the "anchor" cell (the first argument) is changed from $A$1 to $A$41 and instead of referring to the whole column within COUNTA you refer to your A42:A50 range.
SG
One way is to do something like this:
=SUM(OFFSET(A$1,0,0,COUNTA(A),1))
This assumes there are no blank cells within your column of numbers.
The last row is formatted as a Footer Row.
Substitute ; for , in the formula if your regions uses , as a decimal separator.
SG
I need a formula for a series of cells because I can't use the footer. In other words, it needs to be for say H42:H50. I will try modifying your formula. My formula cell is one column to the right of the column with the series of numbers.
Thanks SGIII. Looks like a winner!
Numbers sum of column minus last entry in column?
