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?
