Easy formula question -sum of 1 cell to end

E

Edward

Thanks for looking .
How do you format a formula to display the sum of, let's say A1 to "however
far down the spreadsheet goes" without having to name an ending cell?

This sheet has no end and I need to display the total in a column that keeps
growing.

I hope I phrased this correctly.
 
J

John

Hi Edward
You could do it this way =SUM(A:A), that will cover the full column.
HTH
John
 
P

Pete_UK

You could do:

=SUM(A:A)

which will ignore any blanks and text values in column A - just put
your formula in a column other than A.

Hope this helps.

Pete
 
Top