Easy formula question -sum of 1 cell to end

  • Thread starter Thread starter Edward
  • Start date Start date
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.
 
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
 
Back
Top