 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008no values
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) > 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.....
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.