Sum Function Error

[leblancds]

When attempting to sum a column of numbers in Excel, I'm
getting an error, "XVALUE!". How can I resolve this error?
Thanks,
Dee

 

[Popandopolo]

Hi,
Possibly some of your "numbers" are not formatted as such.
Assuming they are constants, check the formatting via
selecting your range, hit F5 , "Special" ,
Choose "constants" uncheck "Numbers".

HTH,
Puzatiy Popandopolo

 

[Bob Phillips]

Dee,

It sounds to me that you have an error in one of the cells being summed.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Harlan Grove]

When attempting to sum a column of numbers in Excel, I'm
getting an error, "XVALUE!". How can I resolve this error?

If you're using SUM, it only returns errors when there are errors in what
you tell it to sum. If you're using the + operator, it chokes on text that
can't be converted to numbers.