Results 1 to 9 of 9

Sum+IFERROR Help

Threaded View

chriswiec Sum+IFERROR Help 01-27-2013, 08:38 AM
Pete_UK Re: Sum+IFERROR Help 01-27-2013, 08:48 AM
chriswiec Re: Sum+IFERROR Help 01-27-2013, 08:52 AM
Pete_UK Re: Sum+IFERROR Help 01-27-2013, 08:56 AM
chriswiec Re: Sum+IFERROR Help 01-27-2013, 08:58 AM
Pete_UK Re: Sum+IFERROR Help 01-27-2013, 09:07 AM
chriswiec Re: Sum+IFERROR Help 01-27-2013, 09:09 AM
Pete_UK Re: Sum+IFERROR Help 01-27-2013, 09:40 AM
chriswiec Re: Sum+IFERROR Help 01-27-2013, 09:43 AM
  1. #1
    Registered User
    Join Date
    12-27-2012
    Location
    Portland,OR
    MS-Off Ver
    Excel 2010
    Posts
    49

    Sum+IFERROR Help

    Okay Guys,

    I just had help on something similar I found it so useful I wanted to implement it on a different worksheet thought I could figure it out , but no go. Anyway I want cell w12 to read nothing when cell o12 has any integer including 0 in it howver when cells o12 p-u12 and v12 have something in them I need it the formula 012+p12:u12-v12 to come up now there may only be 1 cell between
    p12:u12 that hasa number. If thats too confusing which I'm sure it is i can better try to explain and attach a workbook.

    Right now Ihave this
    =IF((SUM(O13:U13)-V13)=0,"",IFERROR(O13+P13+Q13+R13+S13+T13+U13-V13,""))
    but when cell o13 has a number and nothing else does it reads that number if only o13 has a number I need it to read nothing.

    Any Help Appreciated,

    CW
    Last edited by chriswiec; 01-27-2013 at 08:41 AM. Reason: Added info

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1