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??

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??

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??

=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

If your suspect value is in A2, look at =ISTEXT(A2) and =ISNUMBER(A2)
--
David Biddulph


"Jenny Beech" <JennyBeech@discussions.microsoft.com> wrote in message 
news:2786A77E-F716-4477-A509-5BAD5B5E5357@microsoft.com...
>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??