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

"Ragdyer" wrote:

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.


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Linda" wrote in message
...
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.