Results 1 to 11 of 11

Countif between 2 dates with multiple criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-29-2014
    Location
    Chicago, IL
    MS-Off Ver
    2014
    Posts
    164

    Countif between 2 dates with multiple criteria

    I am trying to count how many 'active' employees I have week to week, with 2 other criteria.

    sheet1 has the data and over time 4 employees have been 'term' (terminated).

    sheet2 is where I need the formula. So, essentially I need a running total of active employees for the week end for rep/Lead/Sup (criteria 1) and ORG (criteria 2) in columns B,c, and d

    You can ignore columns F:I, I'll just copy/paste the formula and adjust as necessary. Thanks for the help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Countif (or maybe it's Sumproduct?) meets two criteria and between two dates
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-14-2014, 12:50 PM
  2. Return dates that match a single criteria (a countif criteria)
    By nickmax1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-07-2014, 12:43 PM
  3. [SOLVED] trying to do a "countif" with multiple ranges and multiple criteria. Countif, Sumproduct?
    By completelyhis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2013, 06:12 PM
  4. Multi-criteria countif functions for dates...possible?
    By Rekli in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-11-2006, 05:51 PM
  5. [SOLVED] Use multiple criteria with COUNTIF: between dates and not blank
    By l.shields in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-13-2006, 02:25 PM
  6. [SOLVED] COUNTIF, dates and blank cell criteria
    By luvthavodka in forum Excel General
    Replies: 6
    Last Post: 06-01-2006, 04:55 PM
  7. [SOLVED] Countif w/ Multiple Criteria-How do I use countif
    By Patrick_KC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2005, 05:05 PM

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