Results 1 to 18 of 18

Count based on 3 criteria including date range

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-07-2008
    Location
    Australia
    Posts
    132

    Count based on 3 criteria including date range

    Hi All,

    I have scoured various responses and can't seem to find an answer that suit s my situation.

    Basically, I would like to match 3 criteria based on a range (Note: using excel 2003)

    Column A includes names, B includes Dates, C includes Yes/no

    I have tried a sumproduct but does not returns 0:
    =SUMPRODUCT(($A$2:$A$7=$E3)*($B$2:$B$7>="Jan-13")*($C$2:$C$7=$K$3))

    Anyone know where I may have gone wrong?

    Regards
    Tim
    Attached Files Attached Files

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