Sum at end of column

  • Thread starter Thread starter Rick Nelson
  • Start date Start date
R

Rick Nelson

This is most probably a simple question for most of you
but all I want to do is total the amount in one column.
Each time I try I get the message that I need to use a
formula. Can this be done without all that extra work?
 
Hi Rick,

No!

=SUM(A:A) will sum all numbers in the entire column A.

=SUM(A1:A25) will sum all numbers in the range A1:A25

Biff
 
Assuming the column you want to total is Column A, type the following
formula into the cell where you want the total to show:

=Sum(A1:A999)

Where A1 is the first cell and A999 is the last cell.

Hope I understood your question.

Cameo
 
Rick,

You need a formula but you can easily do it. Select the cell at the end of
the numbers in the chosen column, and click the auto-sum icon on the
toolbars, the Greek sigma symbol ?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top