Thread: Unable to Sum() Number Values

Hi Everyone,

Can you help me please.
I have a column of numbers. I have formated the cells as number but when I
try to sum() the column it does not calculate, it just leaves the words
Sum() in the cell. Also any cells with zero in them display as 0 and not
0.00 it's as if the contents of the cells are still text but I have
formatted to number.

Does anyone know what's going on and how I get over this.

Thanks for your help it's appreciated.

Best Regards,

Steve Wilson.

Steve

'Numbers' often get stuck as text in Excel. Enter a 1 in a blank cell and
copy it. Highlight the text numbers and then Edit>Paste
special...>Values+Multiply. This will 'shift' them into being seen by Excel
as real numbers

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Always Learning" <NoMoreSpam@MyEmail> wrote in message
news:ur8v6FS4FHA.3976@TK2MSFTNGP15.phx.gbl...
> Hi Everyone,
>
> Can you help me please.
> I have a column of numbers. I have formated the cells as number but when I
> try to sum() the column it does not calculate, it just leaves the words
> Sum() in the cell. Also any cells with zero in them display as 0 and not
> 0.00 it's as if the contents of the cells are still text but I have
> formatted to number.
>
> Does anyone know what's going on and how I get over this.
>
> Thanks for your help it's appreciated.
>
> Best Regards,
>
> Steve Wilson.
>
>

To prove Nick's suggestion, try this. Enter

=SUMPRODUCT(--(A1:A10))

and see if you get the correct results (adjust the range to suit)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Always Learning" <NoMoreSpam@MyEmail> wrote in message
news:ur8v6FS4FHA.3976@TK2MSFTNGP15.phx.gbl...
> Hi Everyone,
>
> Can you help me please.
> I have a column of numbers. I have formated the cells as number but when I
> try to sum() the column it does not calculate, it just leaves the words
> Sum() in the cell. Also any cells with zero in them display as 0 and not
> 0.00 it's as if the contents of the cells are still text but I have
> formatted to number.
>
> Does anyone know what's going on and how I get over this.
>
> Thanks for your help it's appreciated.
>
> Best Regards,
>
> Steve Wilson.
>
>

Hi

Do you see "Sum(...)" or "=Sum(...)" in cell?

When 1st is the case, then you left '=' out from formula. Otherwise check
format of cell with formula - it must'nt be text.


--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )



"Always Learning" <NoMoreSpam@MyEmail> wrote in message
news:ur8v6FS4FHA.3976@TK2MSFTNGP15.phx.gbl...
> Hi Everyone,
>
> Can you help me please.
> I have a column of numbers. I have formated the cells as number but when I
> try to sum() the column it does not calculate, it just leaves the words
> Sum() in the cell. Also any cells with zero in them display as 0 and not
> 0.00 it's as if the contents of the cells are still text but I have
> formatted to number.
>
> Does anyone know what's going on and how I get over this.
>
> Thanks for your help it's appreciated.
>
> Best Regards,
>
> Steve Wilson.
>
>

Also check Tools|Options|View and make sure that Formulas is not checked.

Jerry

Arvi Laanemets wrote:

> Hi
>
> Do you see "Sum(...)" or "=Sum(...)" in cell?
>
> When 1st is the case, then you left '=' out from formula. Otherwise check
> format of cell with formula - it must'nt be text.

Hi Guys,

Thanks for your help and time.
Nicks tip solved it for me.

Best Regards,

Steve Wilson.

"Arvi Laanemets" <garbage@hot.ee> wrote in message
news:%23Rjr$kS4FHA.400@TK2MSFTNGP09.phx.gbl...
> Hi
>
> Do you see "Sum(...)" or "=Sum(...)" in cell?
>
> When 1st is the case, then you left '=' out from formula. Otherwise check
> format of cell with formula - it must'nt be text.
>
>
> --
> Arvi Laanemets
> ( My real mail address: arvil<at>tarkon.ee )
>
>
>
> "Always Learning" <NoMoreSpam@MyEmail> wrote in message
> news:ur8v6FS4FHA.3976@TK2MSFTNGP15.phx.gbl...
> > Hi Everyone,
> >
> > Can you help me please.
> > I have a column of numbers. I have formated the cells as number but when
I
> > try to sum() the column it does not calculate, it just leaves the words
> > Sum() in the cell. Also any cells with zero in them display as 0 and not
> > 0.00 it's as if the contents of the cells are still text but I have
> > formatted to number.
> >
> > Does anyone know what's going on and how I get over this.
> >
> > Thanks for your help it's appreciated.
> >
> > Best Regards,
> >
> > Steve Wilson.
> >
> >
>
>