Results 1 to 3 of 3

countif based on multiple criteria

Threaded View

fabrecass countif based on multiple... 09-23-2011, 08:33 AM
canapone Re: countif based on multiple... 09-23-2011, 08:39 AM
fabrecass Re: countif based on multiple... 09-23-2011, 08:57 AM
  1. 09-23-2011, 08:33 AM #1
    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
« 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