 |
 | 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 / Worksheet Functions / February 2007summing cells that have VALUE errors in them
I need some assistance in doing a SUM function. The cells I am trying to SUM may have an #VALUE error in them. How do I get the SUM to not include those cells? Thanks. Try this: =SUMIF(A1:A10,"<>#VALUE!") Biff >I need some assistance in doing a SUM function. The cells I am trying to >SUM [quoted text clipped - 3 lines] > > Thanks. Thanks much! > Try this: > [quoted text clipped - 9 lines] > > > > Thanks. You're welcome. Thanks for the feedback! Biff > Thanks much! > [quoted text clipped - 12 lines] >> > >> > Thanks. |
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
|
©2009 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.