+ Reply to Thread
Results 1 to 2 of 2

COUNTIF needs to count blank

  1. #1
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    362

    COUNTIF needs to count blank

    I have a table with COUNTIF formulas that has a column (Data tab = H) where VLOOKUP formulas pull dates showing whether a project is completed or not. I need to only count active projects where a condition is that the date is blank. My current formula counts all, including the completed, giving me a wrong count on In Progress projects... please see attached sample... thx
    Attached Files Attached Files

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: COUNTIF needs to count blank

    Maybe this...

    =COUNTIFS(Data!E:E,C9,Data!F:F,L1,Data!G:G,R1,Data!H:H,"")

    If that's not what you want then tell us what result you expect.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Countif fomula to count blank rows
    By gill123 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-26-2015, 03:46 PM
  2. [SOLVED] Countif until blank cell (mutiple blank cells)
    By plasma33 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-07-2015, 01:14 PM
  3. [SOLVED] COUNTIF and IF statements to count non-blank cells only
    By rowena229 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-25-2015, 01:57 PM
  4. [SOLVED] Countif if counting 65536 cells (excel 2003) with count if blank
    By Sc0tt1e in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 12-06-2013, 11:48 AM
  5. [SOLVED] Long Countif statement Not to Count Blank Cells
    By Jiptastic in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-30-2013, 01:44 PM
  6. COUNTIF Issues count blank cells among existing data
    By chrispulliam in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-21-2010, 01:52 AM
  7. How do I use countif to count values excluding blank cells
    By Glenda in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2006, 12:30 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