Results 1 to 2 of 2

COUNTIF formula only after meeting another cell's not null criteria

Threaded View

  1. #1
    Registered User
    Join Date
    04-10-2009
    Location
    Colorado
    MS-Off Ver
    Excel 2016
    Posts
    30

    COUNTIF formula only after meeting another cell's not null criteria

    Having trouble building a nested formula for a COUNTIF function. I have attached a partial example of what I'm trying to achieve. I have a cubed section of patient cases with some simple formula. Each cubed section after this is per Unit (in the example I've only included one Unit example instead of the many that I have). Under the "# New Cases by Unit" I would like the COUNTIF criteria to first look at the "Case ID" column G, only if the cell is NOT NULL, I would like for the COUNTIF function to look at the range of dates in column H "Date of onset of symptoms", if any of the dates match the date in K3, I want it to count how many cases on that selected date from column H.

    Hopefully the attached example is a little clearer than my explanation. Any help would be greatly appreciated!!
    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. Formula to count the cell dates meeting the criteria on another sheet
    By suneeshpillai in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-22-2017, 09:16 AM
  2. [SOLVED] Index and Two Match Criteria- meeting both criteria (need help to repair formula)
    By OilAndGasMan1984 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2017, 10:56 PM
  3. [SOLVED] Count Data Meeting Criteria Across Columns Meeting Criteria
    By idelta in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-06-2015, 03:53 PM
  4. Count rows with multiple null and not null criteria
    By carlostheba in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2014, 05:16 AM
  5. [SOLVED] data meeting criteria but formula somtimes working, then sometimes not
    By summer2010 in forum Excel General
    Replies: 3
    Last Post: 08-13-2012, 05:26 AM
  6. [SOLVED] Finding the corresponding cell of the first value meeting multiple criteria
    By DCPHOLD in forum Tips and Tutorials
    Replies: 7
    Last Post: 12-28-2006, 04:29 AM
  7. selecting row data meeting countif criteria
    By april2579 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2006, 11:25 AM

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