MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Formula/calculation returning a 0 instead of actual sum

• Follow

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

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

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

```=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

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
```
 0

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

```
 0

4 Replies
689 Views

Similiar Articles:

7/23/2012 4:34:50 PM