+ Reply to Thread
Results 1 to 5 of 5

=sum / =ISBlank / =iferror formula needed (or some alternative)

  1. 02-27-2016, 04:28 AM #1
    KClem
    KClem is offline
    Forum Contributor
    Join Date
    11-01-2014
    Location
    London, England
    MS-Off Ver
    Mac 2016
    Posts
    108

    =sum / =ISBlank / =iferror formula needed (or some alternative)

    Hi

    I need a formula that will calculate the increase in some figures each month. However i need it to ignore blank cells. I am using a basic =sum formula (=IFERROR(SUM(B3-A3),"")) but if there is a blank cell before the first number i am deducting it produces a minus.

    Thanks in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-27-2016, 04:40 AM #2
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: =sum / =ISBlank / =iferror formula needed (or some alternative)

    something like that?
    =IFERROR(IF((B3-A3)<=0,"",B3-A3),"")
    Last edited by sandy666; 02-27-2016 at 04:55 AM. Reason: typo
    Reply With QuoteRegister To Reply
  3. 02-27-2016, 04:43 AM #3
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: =sum / =ISBlank / =iferror formula needed (or some alternative)

    Perhaps = MAX((b3-a3),0) ( The SUM function you used is not necessary in this case)
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  4. 03-02-2016, 05:59 AM #4
    KClem
    KClem is offline
    Forum Contributor
    Join Date
    11-01-2014
    Location
    London, England
    MS-Off Ver
    Mac 2016
    Posts
    108

    Re: =sum / =ISBlank / =iferror formula needed (or some alternative)

    Thanks Sandy and Pepe Le Mokko. The Max formula was more consistently accurate. :-)
    Reply With QuoteRegister To Reply
  5. 03-02-2016, 08:21 AM #5
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: =sum / =ISBlank / =iferror formula needed (or some alternative)

    You're welcome
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IFERROR(MATCH & IFERROR(SMALL Help Needed
    By chad328 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-17-2016, 06:34 AM
  2. [SOLVED] ISBLANK formula that goes off of IFERROR formula
    By BoundToExcel in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-06-2016, 04:18 PM
  3. [SOLVED] Iferror formula help needed
    By bigband1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-02-2015, 10:42 AM
  4. Extension of IFERROR/VLOOKUP formula help needed.
    By conwayroger25 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2014, 12:55 PM
  5. [SOLVED] Better way, IsBlank and Vlookup & Iferror
    By jtmeunier in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-27-2013, 06:51 PM
  6. [SOLVED] IFERROR / ISBLANK formula query
    By zhb12810 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2012, 04:05 AM
  7. IFERROR (alternative)
    By mxblast in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2009, 12:55 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1