HELP!!!!!!!!!

[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.

 

[Gord Dibben]

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

 

[Ragdyer]

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.

 

[Bob I]

Select the cells and look at the Status bar at the bottom of the Excel
window for "Sum"

 

[Linda]

Thank you so much for your help. This worked out perfectly and I learned how
to use a formula!!!!!!!!! THANK YOU AGAIN!!!

 

[RagDyeR]

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,D520)

Or even
=Sum(C5:C20,D520,E3,F3)