Results 1 to 7 of 7

Sumproduct gives Value error

Threaded View

tabkaz Sumproduct gives Value error 02-07-2018, 08:58 AM
Glenn Kennedy Re: Sumproduct gives Value... 02-07-2018, 08:59 AM
xlnitwit Re: Sumproduct gives Value... 02-07-2018, 09:01 AM
tabkaz Re: Sumproduct gives Value... 02-07-2018, 09:32 AM
Phuocam Re: Sumproduct gives Value... 02-07-2018, 09:41 AM
tabkaz Re: Sumproduct gives Value... 02-08-2018, 01:48 AM
Glenn Kennedy Re: Sumproduct gives Value... 02-07-2018, 09:45 AM
  1. #1
    Registered User
    Join Date
    02-27-2012
    Location
    UK
    MS-Off Ver
    Excel 365
    Posts
    65

    Sumproduct gives Value error

    I have a data on multiple sheets, I am using Sumproduct formula for summation of values matching date and time, later on, a product of a time duration and finally a division by 60. But when there is any blank cell for multiplication it gives value error.
    Also, want to compact this formula as data are in multiple 5 sheets.

    =SUMPRODUCT(('BR1 grid'!$A$7:$A$54=$A3)*('BR1 grid'!$C$5:$AG$5=B$2),'BR1 grid'!$C$7:$AG$54)*'BR1 grid'!$L$1/60+SUMPRODUCT(('BR2 grid'!$A$7:$A$54=$A3)*('BR2 grid'!$C$5:$AG$5=B$2),'BR2 grid'!$C$7:$AG$54)*'BR2 grid'!$L$1/60

    See sheet 4 yellow shaded
    Attached Files Attached Files
    Last edited by tabkaz; 02-07-2018 at 09:25 AM. Reason: Adds Attachment

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sumproduct with Error #Value!
    By minhtien1900 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-26-2017, 12:05 PM
  2. [SOLVED] Sumproduct error
    By Ravana in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-02-2015, 04:42 AM
  3. [SOLVED] Sumproduct error to #VALUE!
    By leakhna in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-25-2015, 10:52 PM
  4. vba SumProduct Error
    By gingank in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2012, 04:31 AM
  5. IF with SUMPRODUCT error
    By ddub25 in forum Excel General
    Replies: 4
    Last Post: 02-16-2012, 08:47 AM
  6. Sumproduct Error
    By ltmaiyk in forum Excel General
    Replies: 4
    Last Post: 11-05-2009, 11:21 AM
  7. [SOLVED] Error values:DIV/0! error in SumProduct formula with no division
    By Jerry W. Lewis in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1