Formula/calculation returning a 0 instead of actual sum

J

Jenny Beech

I am using 2007 and I have a workbook that returns a "0" instead of the
actual sum. I have tried using @sum formula and just adding the cells
together.

Any ideas??
 
G

Gary''s Student

Sounds like your values are not "real" numbers. They may be Text values.
Another possibility is you may be in manual calculation mode.
 
J

Jenny Beech

I checked the calculation mode and it is automatic.

How do I know if the values are real numbers?
 
D

Dave Peterson

=isnumber(A1)
will return true if A1 contains a number.

=count(a1:A10)
will return the number of numbers in A1:A10

=counta(a1:a10)
will return the number of non-empty cells in A1:A10

One way to convert the text numbers to number numbers
Select an empty cell
edit|copy
select the range to fix
Edit|paste special|check add and values

Then look at your =sum() formula.
 

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

Newbie Help - IF Yes No Function 0
Use TODAY() function as the criteria in a SUMIF formula 1
Using SUM(INDIRECT()) 2
Time Sum in Excel 1
Sum of values in column A based on 0/1 of column B 2
Multiple logic functions with multiple sums 2
Multiple Columns in Sum Range using SUMIFS 1
Using =SUM...just can't figure this simple thing out... 2

Top