+ Reply to Thread
Results 1 to 2 of 2

Sumproduct returns 0 when it should be 1

  1. #1
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Sumproduct returns 0 when it should be 1

    Hi
    in the attached sheet, the values highlighted in yellow, obtained with =SUMPRODUCT(--(B4:H4=TODAY())) should return 1 in cells H4 and H5 but return 0 although today's date is present in both rows ?
    Thanks for any help
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Sumproduct returns 0 when it should be 1

    Ok, got it, it's due to the circular references. I corrected that and it's OK

+ 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 formula returns #VALUE!
    By deniseturan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-19-2019, 05:24 PM
  2. [SOLVED] Sumproduct with criteria - returns zero value
    By adsako in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-25-2018, 06:49 AM
  3. [SOLVED] SUMPRODUCT Returns #VALUE
    By MatthewIJClark in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-19-2018, 05:24 AM
  4. Sumproduct returns #Value
    By cartica in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-24-2013, 01:33 PM
  5. [SOLVED] Sumproduct returns #VALUE!
    By rdd2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-16-2013, 02:12 PM
  6. SumProduct Returns Zero
    By ronnomad in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-10-2006, 09:50 AM
  7. [SOLVED] sumproduct returns zero
    By vacation in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-31-2006, 04:00 PM

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