Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula/calculation returning a 0 instead of actual sum
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?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula/calculation returning a 0 instead of actual sum
Sounds like your values are not "real" numbers. They may be Text values.
Another possibility is you may be in manual calculation mode. -- Gary''s Student - gsnu200908 "Jenny Beech" wrote: 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?? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula/calculation returning a 0 instead of actual sum
I checked the calculation mode and it is automatic.
How do I know if the values are real numbers? "Gary''s Student" wrote: Sounds like your values are not "real" numbers. They may be Text values. Another possibility is you may be in manual calculation mode. -- Gary''s Student - gsnu200908 "Jenny Beech" wrote: 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?? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula/calculation returning a 0 instead of actual sum
=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. Jenny Beech wrote: I checked the calculation mode and it is automatic. How do I know if the values are real numbers? "Gary''s Student" wrote: Sounds like your values are not "real" numbers. They may be Text values. Another possibility is you may be in manual calculation mode. -- Gary''s Student - gsnu200908 "Jenny Beech" wrote: 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?? -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula/calculation returning a 0 instead of actual sum
If your suspect value is in A2, look at =ISTEXT(A2) and =ISNUMBER(A2)
-- David Biddulph "Jenny Beech" wrote in message ... I checked the calculation mode and it is automatic. How do I know if the values are real numbers? "Gary''s Student" wrote: Sounds like your values are not "real" numbers. They may be Text values. Another possibility is you may be in manual calculation mode. -- Gary''s Student - gsnu200908 "Jenny Beech" wrote: 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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Calculation returning 19:00 | Excel Discussion (Misc queries) | |||
Returning calculation status | Excel Worksheet Functions | |||
returning calculation based on number | Excel Worksheet Functions | |||
Vlookup: returning the value below the actual row | Excel Discussion (Misc queries) |