+ Reply to Thread
Results 1 to 7 of 7

Sumproduct gives Value error

Hybrid View

  1. #1
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2024
    Posts
    6,175

    Re: Sumproduct gives Value error

    Edit:

    =SUMPRODUCT((Sheet2!A3:A5=A3)*(Sheet2!C1:D1=B2),Sheet2!C3:D5*N(Sheet2!F2)/60)
    +SUMPRODUCT((Sheet3!A3:A5=A3)*(Sheet3!C1:D1=B2),Sheet3!C3:D5*N(Sheet3!F2)/60)
    +SUMPRODUCT((Sheet4!A3:A5=A3)*(Sheet4!C1:D1=B2),Sheet4!C3:D5*N(Sheet4!F2)/60)

  2. #2
    Registered User
    Join Date
    02-27-2012
    Location
    UK
    MS-Off Ver
    Excel 365
    Posts
    65

    Re: Sumproduct gives Value error

    Thanks....
    it's now working...though not sure what the 'N' purpose is...

+ Reply to Thread

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