AutoSum

Hi

When I highlight a range of cells AutoSum misses certain cells, even though
all cells have the same format. The same applies when I change the format to
General, Number or Text.

Any Ideas.

Thanks
Alec

Do you have blank cells, Autosum goes to the blanks and stops there.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Alectrical" <Alectrical@discussions.microsoft.com> wrote in message
news:ED34DF0C-680C-4747-A870-6EFC04ED0E60@microsoft.com...
> Hi
>
> When I highlight a range of cells AutoSum misses certain cells, even
though
> all cells have the same format. The same applies when I change the format
to
> General, Number or Text.
>
> Any Ideas.
>
> Thanks
> Alec

No there are no blank cells, for example AutoSum stop calculating at 5.5 in
the following sequence of numbers.

4
4
4
4
4
4
5.5
9
22
180


"Bob Phillips" wrote:

> Do you have blank cells, Autosum goes to the blanks and stops there.
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Alectrical" <Alectrical@discussions.microsoft.com> wrote in message
> news:ED34DF0C-680C-4747-A870-6EFC04ED0E60@microsoft.com...
> > Hi
> >
> > When I highlight a range of cells AutoSum misses certain cells, even
> though
> > all cells have the same format. The same applies when I change the format
> to
> > General, Number or Text.
> >
> > Any Ideas.
> >
> > Thanks
> > Alec
>
>
>

Sorry, works fine for me. All I can suggest is to edit each number (F2) and
make sure that the format takes okay.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Alectrical" <Alectrical@discussions.microsoft.com> wrote in message
news:5B31C6F4-C44C-4071-BAFC-3B2E80326477@microsoft.com...
> No there are no blank cells, for example AutoSum stop calculating at 5.5
in
> the following sequence of numbers.
>
> 4
> 4
> 4
> 4
> 4
> 4
> 5.5
> 9
> 22
> 180
>
>
> "Bob Phillips" wrote:
>
> > Do you have blank cells, Autosum goes to the blanks and stops there.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "Alectrical" <Alectrical@discussions.microsoft.com> wrote in message
> > news:ED34DF0C-680C-4747-A870-6EFC04ED0E60@microsoft.com...
> > > Hi
> > >
> > > When I highlight a range of cells AutoSum misses certain cells, even
> > though
> > > all cells have the same format. The same applies when I change the
format
> > to
> > > General, Number or Text.
> > >
> > > Any Ideas.
> > >
> > > Thanks
> > > Alec
> >
> >
> >

Some of your numbers may actually be text.

Re-formatting alone does not do the trick.

Format all to General.

Copy an empty cell.

Select numbers and Paste Special>Add>OK>Esc.


Gord Dibben MS Excel MVP

On Fri, 11 Aug 2006 02:04:01 -0700, Alectrical
<Alectrical@discussions.microsoft.com> wrote:

>Hi
>
>When I highlight a range of cells AutoSum misses certain cells, even though
>all cells have the same format. The same applies when I change the format to
>General, Number or Text.
>
>Any Ideas.
>
>Thanks
>Alec