+ Reply to Thread
Results 1 to 6 of 6

How to count blank cells based on adjacent cells with names?

  1. #1
    Registered User
    Join Date
    07-29-2016
    Location
    Manila, Philippines
    MS-Off Ver
    2010
    Posts
    79

    How to count blank cells based on adjacent cells with names?

    Hello All,

    Can I ask for your help with these,

    The sheet named "Data" contain names on Column A. The next column is either left blank or marked with "Done" if a report was made.

    How do I combine "Countif" to count for names and the condition to look for blanks based on the names.

    End goal is to count the number of blanks per name which will be referenced on sheet "Report".
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,106

    Re: How to count blank cells based on adjacent cells with names?

    I presume you want the formula in column B of the Report sheet - if so, put this formula in B2 of that sheet:

    =COUNTIFS(Data!A:A,A2,Data!B:B,"")

    then copy down.

    Hope this helps.

    Pete

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,239

    Re: How to count blank cells based on adjacent cells with names?

    Try this...
    =COUNTIFS(Data!$A$2:$A$13,Report!A2,Data!$B$2:$B$13,"<>Done")
    copied down
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    07-29-2016
    Location
    Manila, Philippines
    MS-Off Ver
    2010
    Posts
    79

    Re: How to count blank cells based on adjacent cells with names?

    Thank you both kind sirs! Both formulas work as intended!

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,106

    Re: How to count blank cells based on adjacent cells with names?

    You're welcome - thanks for the rep.

    Pete

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,239

    Re: How to count blank cells based on adjacent cells with names?

    happy to help and thanks for the feedback

+ 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. Replies: 12
    Last Post: 05-29-2018, 05:11 PM
  2. [SOLVED] Find last max. value in list and count all previous non-blank cells in adjacent column
    By zeegerman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-25-2015, 05:01 PM
  3. Count blank cells in a range and contiguous blank cells also as single cells! Tricky One!
    By SebastianColombia in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-31-2015, 02:32 PM
  4. Replies: 4
    Last Post: 02-11-2015, 09:02 AM
  5. A function that will count cells based on the value of the adjacent cells
    By grimston in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-18-2014, 02:47 PM
  6. Counting blank cells based on non adjacent criteria
    By FrankMcG in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-30-2013, 04:47 PM
  7. Replies: 4
    Last Post: 09-12-2013, 11:32 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