no values

  • Thread starter Thread starter kaja
  • Start date Start date
K

kaja

hai i am having a values on the columns a and b in the column c i like
to have the total. i used sum function to make total it shows 0 always
whether there is value in a and b or not will you can tell me how to
avoid the 0.....
 
Can you post the formula you're using?

Also...some things to check:
Make sure that the values in Col_A and Col_B
are numbers...NOT numeric text.

Examples:
123.....number
'123....numeric text

You can test individual values with a formula like this:
=ISNUMBER(A2)

If the values are numbers...this kind of formula should work for you:
=SUM(A2:B2)

If the values are numeric text....try this:
=SUMPRODUCT(--(A2:B2))

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Back
Top