Sum Function Error

  • Thread starter Thread starter leblancds
  • Start date Start date
L

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
 
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
 
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)
 
leblancds said:
When attempting to sum a column of numbers in Excel, I'm
getting an error, "XVALUE!". How can I resolve this error?
Click to expand...

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.
 
Back
Top