HELP!!!!!!!!!

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

I'm very new with excel. Can someone tell me how to total a simple column of
dollar amounts. Is there a button that I should click on? I really don't
want to use formulas on a long list.
Thank you so much if you can help.
 
In B1 enter =SUM(A:A)

Assuming your dollar amouts are column A

For a range use =SUM(A1:A123)

OR.............select the range to sum then hit the AutoSum icon(looks like
a sideways M)


Gord Dibben MS Excel MVP
 
Why not try a very simple, elementary formula?

You'll eventually have to get into using them if you're going to continue to
use XL.

To total a range, simply enter in the cell where you wish to see the total:
=Sum(
Then enter the top cell, say it's C5,
=Sum(C5
type a colon to signify a range reference,
=Sum(C5:
Then add the last cell of the range, say C20,
=Sum(C5:C20
And finish with the closing parens,
=Sum(C5:C20)

And you now have a formula that will total the cells that fall within the
referenced range.
 
Select the cells and look at the Status bar at the bottom of the Excel
window for "Sum"
 
Thank you so much for your help. This worked out perfectly and I learned how
to use a formula!!!!!!!!! THANK YOU AGAIN!!!
 
You're welcome, and appreciate the feed-back ... AND
Another lesson to add functionality to the Sum() function:

Where I mentioned the colon ( : ) was a range reference delimiter, you can
also use the comma ( , ) to add additional cells and/or ranges to be totaled
by the same formula.

=Sum(C5:C20,D5:D20)

Or even
=Sum(C5:C20,D5:D20,E3,F3)
 
Back
Top