+ Reply to Thread
Results 1 to 4 of 4

Unable to resolve #DIV/0! in sumproduct function

  1. 03-22-2014, 01:39 AM #1
    ruraljur0r
    ruraljur0r is offline
    Registered User
    Join Date
    02-13-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    7

    Unable to resolve #DIV/0! in sumproduct function

    Hello
    I am struggling to resolve the #DIV/0! error within my summary worksheet, see attached sample spreadsheet:
    WORKSHEET Status of Welds - contains the data
    WORKSHEET Daily Weld Dia - contains the summary
    WORKSHEET What I Want - self explanatory

    What I'm trying to acheive is a total sum of dia inches welded by each welder each day. I originally had a clumsy workaround with upstream formulas to eliminate #DIV/0! but now urgently need to correct this.

    Any help is greatly appreciated.

    Thanks in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-22-2014, 02:10 AM #2
    Jacc
    Jacc is offline
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Unable to resolve #DIV/0! in sumproduct function

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    The problem is caused by the zero in B18.
    Try this formula in cell B2. It's an array formula so you have to enter it with Ctrl + Shift + Enter.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
    Reply With QuoteRegister To Reply
  3. 03-22-2014, 02:44 AM #3
    ruraljur0r
    ruraljur0r is offline
    Registered User
    Join Date
    02-13-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Unable to resolve #DIV/0! in sumproduct function

    Hi Jacc
    I'm relieved I was almost there. I had played around with different versions of if(iserror( but obviously missed this one.

    Thanks for the prompt response!
    Reply With QuoteRegister To Reply
  4. 03-23-2014, 09:57 AM #4
    Jacc
    Jacc is offline
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Unable to resolve #DIV/0! in sumproduct function


    ---------
    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. Unable to resolve Runtime error 91
    By jr2007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2013, 07:37 AM
  2. Sumproduct with OR criteria, unable to properly subtract all the AND cases.
    By psytroniks in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-04-2012, 01:24 PM
  3. Resolve a problem with a sumproduct formula
    By dc123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-14-2008, 11:55 AM
  4. how to resolve this after Substitute function?
    By stan123 in forum Excel General
    Replies: 12
    Last Post: 03-02-2007, 04:51 PM
  5. unable to grasp SUMPRODUCT
    By toddbob in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-04-2006, 10:50 PM

Tags for this Thread

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