Results 1 to 2 of 2

Thread: SUMPRODUCT help

  1. #1

    SUMPRODUCT help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need help using the SUMPRODUCT function.

    Firstly, I need to sum the total number of blank cells between a certain defined week range. For example, Sheet1 will display totals, Sheet2 has the data to be counted. I need to count blank cells in Column O (Sheet2) from a date in Column A (Sheet1), to a date in Column B(Sheet1). Secondly, I need the answer to this displayed on Sheet1. Using SUMPRODUCT I've only been able to return #NAME? or #VALUE?

    I'm completely stuck and have been trying for the better part of three hours. Any help is appreciated.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,467
    Articles
    0
    Excel Version
    Excel 2016
    Perhaps something like:

    =SUMPRODUCT((Sheet1!$A$2:$A$100<=A2)*(Sheet1!$B$2:$B$100>=A2)*(Sheet1!$O$2:$O$100=""))

    Where A2 on active sheet has date to check for... adjust ranges to suit, but don't use whole columns.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •