Results 1 to 3 of 3

COUNTIFS date from Column A > date in Column B

Threaded View

benoit_brindamour COUNTIFS date from Column A >... 10-27-2011, 12:16 PM
daddylonglegs Re: I would like to COUNTIFS... 10-27-2011, 01:06 PM
benoit_brindamour Re: COUNTIFS date from Column... 10-31-2011, 11:04 AM
  1. #1
    Registered User
    Join Date
    10-27-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    COUNTIFS date from Column A > date in Column B

    Hi everyone,
    backround:
    Here's the problem. We need to meet users before they leave from the company. the only problem is sometimes we get the departure emails after they leave. I need a monthly summary of the people we dont meet, that we recieved the email before they leave.
    or i cant figure the red part out, I need a count of: departure date(columnA) between x and y AND met user(column C) = no AND departure date(column A) > email reception date(column B)

    Im already using a countifs formula to determine if we met users leaving and right now I have a hidden field with a simple > formula but I would really like to eliminate it. I had also tried the sumproduct with -- that i could just subtract from the countifs but I could not find a way to limit it to a date range.

    thanks
    Last edited by benoit_brindamour; 10-31-2011 at 11:04 AM.

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