Results 1 to 5 of 5

How to use COUNTIFS and COUNTIF with multiple criteria using dates

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-20-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    108

    How to use COUNTIFS and COUNTIF with multiple criteria using dates

    I have a spreadsheet with a due date column J and a status column F.

    I want to count the number of cells that are overdue in J, but if the status column in F says "complete" or "closed", it will not be counted.

    Any help would be greatly appreciated. Thank you.
    Last edited by rowena229; 09-15-2020 at 02:12 PM.

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 COUNTIFS with multiple criteria
    By rakotonirinas in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-19-2020, 12:06 PM
  2. [SOLVED] Vertical and Horizontal Countif between dates with multiple criteria
    By ShakJames in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-16-2019, 06:17 AM
  3. [SOLVED] Using Multiple Criteria With Countif or Countifs Formula
    By kozakb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2019, 06:37 PM
  4. [SOLVED] Countif between 2 dates with multiple criteria
    By Sasquatch2014 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-15-2015, 09:22 AM
  5. [SOLVED] Countif between 2 dates and multiple criteria
    By Sasquatch2014 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-14-2015, 10:55 AM
  6. Countifs criteria between two dates
    By Si902 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-24-2011, 05:47 AM
  7. [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

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