I'm trying to use the sum function to add numbers in a
column. When I higlight and click sum, it takes my first cell out and
replaces it with a formula. If I click below it and select sum, it
puts a formula in. After inserting what I want the sum of (ex.
C20:C58) I hit the enter key and gives me 0.00. I've tried doing the
sum while having the cells formatted as both number currency, but I
don't have luck either way. Any ideas what I may be doing wrong?



--
caroofikus
------------------------------------------------------------------------
caroofikus's Profile: http://www.excelforum.com/member.php...o&userid=23829
View this thread: http://www.excelforum.com/showthread...hreadid=374837

Why don't you just use

=SUM(A2:A50)

and type it in an empty cell (replace A2:A50 with your range)

--
Regards,

Peo Sjoblom


"caroofikus" wrote
in message ...

I'm trying to use the sum function to add numbers in a
column. When I higlight and click sum, it takes my first cell out and
replaces it with a formula. If I click below it and select sum, it
puts a formula in. After inserting what I want the sum of (ex.
C20:C58) I hit the enter key and gives me 0.00. I've tried doing the
sum while having the cells formatted as both number currency, but I
don't have luck either way. Any ideas what I may be doing wrong?



--
caroofikus
------------------------------------------------------------------------
caroofikus's Profile:
http://www.excelforum.com/member.php...o&userid=23829
View this thread: http://www.excelforum.com/showthread...hreadid=374837

caroofikus Wrote:
I'm trying to use the sum function to add numbers in a
column. When I higlight and click sum, it takes my first cell out and
replaces it with a formula. If I click below it and select sum, it
puts a formula in. After inserting what I want the sum of (ex.
C20:C58) I hit the enter key and gives me 0.00. I've tried doing the
sum while having the cells formatted as both number currency, but I
don't have luck either way. Any ideas what I may be doing wrong?

Hi,
Peo's example will work just fine, but to let you know what you are
doing wrong.
You are highliting the range before you go click the sum function.
When you highlight a range notice that the first cell you've
highlighted
is a lighter color than the rest. That is your active cell. Thats were
the formula will go.
Try this, Select the cell where you want the formula to be (that will
be the active cell).
THEN click on the sum function, THEN highlight your range.

Hope this helps
Dave


--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=374837