 |
 | 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 / October 2007text in a cell in a numeric formula
Hi, If I'm adding say 4 cells, and one cell has text in it, is there a way to disregard the text and get the numeric total? I get a #value! error now. I can't ignore the cell because sometimes there are numbers in it. I could use shading, but I really need a text designator in the cell. Any way to do this would be appreciated. Thanks, --Randy Starkey Use the SUM function: A1 = 1 A2 = text A3 = 1 A4 = 1 =A1+A2+A3+A4 returns #VALUE! =SUM(A1:A4) returns 3  SignatureBiff Microsoft Excel MVP > Hi, > [quoted text clipped - 8 lines] > > --Randy Starkey Bill, Here's my actual scenario... A1+A5+A10+A15 What can I do with that? Thanks! --Randy > Use the SUM function: > [quoted text clipped - 19 lines] >> >> --Randy Starkey As previously stated use SUM =SUM(A1,A5,A10,A15) or the somewhat unnecessary =N(A1)+N(A5)+N(A10)+N(A15) SignatureRegards, Peo Sjoblom > Bill, > [quoted text clipped - 31 lines] >>> >>> --Randy Starkey Try this: =sum(A1,A5,A10,A15) Hope this helps. Pete By the way, it was Biff, not Bill !! On Oct 9, 4:30 pm, "Randy Starkey" <randy.starkeyNOS...@NOSPAMvictorychurch.com> wrote: > Bill, > [quoted text clipped - 37 lines] > > - Show quoted text - Cool. Thanks everyone! --Randy Starkey > Try this: > [quoted text clipped - 51 lines] >> >> - Show quoted text - You're welcome. Pete On Oct 10, 4:55 am, "Randy Starkey" <randy.starkeyNOS...@NOSPAMvictorychurch.com> wrote: > Cool. Thanks everyone! > [quoted text clipped - 61 lines] > > - Show quoted text -
|
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.