Sum of Column

  • Thread starter Thread starter Mike Kiekover
  • Start date Start date
M

Mike Kiekover

What would be the expression to get the sum of a column with a range
starting at a specified row (cell) but continuing down as far as cells
contain values.

I'm guessing its a simple one, but can't seem to come up with it.

Mike
 
=sum(a2:a65536)

(I don't care where the data ends--I'll just go to the bottom of the column.)
 
Presuming, you're totaling at the bottom of the column as per normal,
shouldnt this be either "=sum(a2:a65536)" or "=sum(A2:A" &
range(a65536).end(xlup).row-1)" to exclude the column total from the sum??
 
If the formula is in the same column/range, then you'd want to exclude it from
the formula.

But I didn't see anything in the original post that indicated this.

ps. Lots of times, I'd put the totals in row 1, headers in row 2 and freeze
panes to make sure that those two rows were always visible. It can make life
easier for other things, too.
 
Back
Top