Problems with Sum Function

[caroofikus]

I'm trying to use the sum function to add numbers in
column. When I higlight and click sum, it takes my first cell out an
replaces it with a formula. If I click below it and select sum, i
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 th
sum while having the cells formatted as both number currency, but
don't have luck either way. Any ideas what I may be doing wrong
:confused

 

[Peo Sjoblom]

Why don't you just use

=SUM(A2:A50)

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

 

[Piranha]

I'm trying to use the sum function to add numbers in
column. When I higlight and click sum, it takes my first cell out an
replaces it with a formula. If I click below it and select sum, i
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 th
sum while having the cells formatted as both number currency, but
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 ar
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'v
highlighted
is a lighter color than the rest. That is your active cell. Thats wer
the formula will go.
Try this, Select the cell where you want the formula to be (that wil
be the active cell).
THEN click on the sum function, THEN highlight your range.

Hope this helps
Dav