Sum Function Problem!!

G

Guest

I have created a worksheet with dates going down the left hand side and
various numbers on the right. There is a clear column between the two. I want
to use the sum function to add up the numbers on the right, but when I do the
answer is a date, not the sum of the answers!?!

Any ideas gratefully received!!
 
G

Guest

The cell you are using was previously formatted as a date. Format the cell
as a number >> Format|Cells|Number
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum with a slash "/" 6
Time Sum in Excel 1
Sum Function not working right 2
the decimals extends after the sum function 2
Calculate pivot table items in 2007 2
Using sum function with absolute numbers 6
excel sum function 2
How to add only the adding filtered result using SUM function? 7

Top