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



On Sat, 6 Sep 2008 09:57:04 -0700, Linda
wrote:

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.

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.

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.

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

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Linda" wrote in message
...
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.

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

Linda wrote:

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.