Results 1 to 7 of 7

SUMPRODUCT Formula results on #VALUE

Threaded View

  1. #1
    Registered User
    Join Date
    12-15-2012
    Location
    Manila
    MS-Off Ver
    Excel 2003
    Posts
    9

    SUMPRODUCT Formula results on #VALUE

    Hi all!

    I have a little problem here with a file I am working. On my workbook I have 6 sheets:
    Sched, CM Report, Using Held Calls, Using Lunch, Held Calls and Lunch sheets.

    On the Using Held Sheet and Using Lunch Sheet I have the names of my agents on Col A and on Col B-H are specific dates. For Cells B3:H15 I inserted a formula. Here is an example of the formula:

    =IF(Sched!B3="y",SUMPRODUCT(('Held Calls'!$A$2:$A$343=$A3)*('Held Calls'!$B$2:$B$343=B$2)*(('Held Calls'!$C$2:$C$343))),"RD")

    This formula works perfectly for Held Calls but on my Using Lunch it results to #VALUE. I have tried everything I know to have this resolved but I am stomped!

    I attached here my worksheet to get a better picture of my issue if I failed totally in explaining it.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMPRODUCT formula not returning correct results
    By CityInspector in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2012, 04:04 PM
  2. [SOLVED] SUMPRODUCT() results in an error
    By BNCOXUK in forum Excel General
    Replies: 16
    Last Post: 11-01-2012, 10:50 AM
  3. Excluding #N/A results from a SUMPRODUCT
    By Iscariot in forum Excel General
    Replies: 2
    Last Post: 04-03-2009, 07:38 AM
  4. Sumproduct formula not giving expected results
    By Shocked in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-30-2008, 03:12 PM
  5. Different results from SumProduct - Why?
    By Spellbound in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-02-2007, 05:20 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