+ Reply to Thread
Results 1 to 3 of 3

Sumproduct-het #VALUE! error.

  1. #1
    Registered User
    Join Date
    02-08-2007
    Posts
    5

    Sumproduct-het #VALUE! error.

    I am trying to get a simple count from this formula in a cell that is formatted general I het #VALUE! error. I change the format of the cell to number but come up w/ the same error.

    Formula:

    =SUMPRODUCT((J4:J98="x")*(CV4:CV98="M")*(CW4:CW98>=0)*(CW4:CW98<=19))

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    The formula looks OK to me so I'd suggest you have problems with the data. Do you have any #VALUE! errors in those ranges

  3. #3
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881
    If there are no obvious errors in your data, you can always evaluate the formula in Excel. Select the cell that has your formula, and click Tools - Formula Auditing - Evaluate Formula. Click the Evaluate button in that window to step through each part of the formula.

    My guess is that at some point you will see a "VALUE" error, which would most likely be the root cause of the whole formula evaluating to this error.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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