+ Reply to Thread
Results 1 to 3 of 3

countif based on multiple criteria

  1. 09-23-2011, 08:33 AM #1
    fabrecass
    fabrecass is offline
    Forum Contributor
    Join Date
    02-01-2011
    Location
    london, england
    MS-Off Ver
    Excel 2016
    Posts
    179

    countif based on multiple criteria

    hi guys,

    i need a formula that returns a count of how many cells are blank IF a certain date has passed and another cell is not blank.

    so IF column L is not blank AND column O is blank AND the date in column P is in the past then return 1. I've tried variations on COUNTIF but can't get it right!

    can anyone help?
    Last edited by fabrecass; 09-23-2011 at 08:36 AM.
    Reply With QuoteRegister To Reply
  2. 09-23-2011, 08:39 AM #2
    canapone
    canapone is offline
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: countif based on multiple criteria

    Hi,

    maybe

    =SUMPRODUCT((L2:L1000<>"")*(O2:O1000="")*(P2:P1000<TODAY()))

    or if in A1 your reference date

    =SUMPRODUCT((L2:L1000<>"")*(O2:O1000="")*(P2:P1000<A1))



    Regards
    Reply With QuoteRegister To Reply
  3. 09-23-2011, 08:57 AM #3
    fabrecass
    fabrecass is offline
    Forum Contributor
    Join Date
    02-01-2011
    Location
    london, england
    MS-Off Ver
    Excel 2016
    Posts
    179

    Re: countif based on multiple criteria

    thank you!! perfect.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1