Results 1 to 12 of 12

Sumproduct not working

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-19-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    137

    Sumproduct not working

    I'm trying to get a total from my using a Sumproduct formula. In Sheet2 is where the data is that I'm trying to extract. On Sheet2 column I through T is where the Month totals are that I'm trying to extract. I get a result of #VALUE!.

    =SUMPRODUCT(--(Sheet2!$C:$C=$A$2),--(Sheet2!$E:$E=$B2),--(Sheet2!$I:$T=$C2),(Sheet2!I:T))

    Name ID# Date
    Tracey 123456 October


    Thank you.
    Attached Files Attached Files
    Last edited by yuenk; 12-22-2016 at 12:11 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMPRODUCT not working
    By Karroog in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-10-2014, 03:19 PM
  2. SUMPRODUCT not working, please help.
    By nejjoan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-11-2014, 02:12 AM
  3. [SOLVED] Sumproduct not working
    By Chetansuri in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-03-2014, 01:32 AM
  4. [SOLVED] Sumproduct = not working the way I want : )
    By Runnin L8 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2013, 04:22 PM
  5. [SOLVED] SUMPRODUCT not working
    By User3 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-01-2013, 06:31 AM
  6. [SOLVED] Sumproduct Not Working
    By carl in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-15-2006, 02:15 PM
  7. [SOLVED] SUMPRODUCT Not Working
    By Scott in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2005, 10:50 AM

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