HELP!!!!!!!!!
 

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.

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.

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.

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.

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.

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.