+ Reply to Thread
Results 1 to 4 of 4

Count cells with a condition

  1. #1
    Registered User
    Join Date
    11-07-2019
    Location
    Lithuania
    MS-Off Ver
    Office 2013
    Posts
    52

    Count cells with a condition

    Hello,

    I have a worksheet with some Date data. What i need is to count how many times in a certain date there were "Yes" or "No"

    Sample workbook attached.

    Thank you for your help.
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Count cells with a condition

    Please try at D3

    =COUNTIFS($A$2:$A$11,LOOKUP(9^9,$D1:D1),$B$2:$B$11,D2)
    Attached Files Attached Files

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Count cells with a condition

    Use formulae like this one:

    =COUNTIFS($A:$A,D1,$B:$B,D2)

    You may need ; as the separator.

    Advice: get rid of the merged cells. Horrible things. They make constructing formulae awkward and make more complicated formulae really horrible. If you need to, format them as "Format cells/Alignment/Horizontal/Centre across selection"
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  4. #4
    Registered User
    Join Date
    11-07-2019
    Location
    Lithuania
    MS-Off Ver
    Office 2013
    Posts
    52

    Re: Count cells with a condition

    Both answers look and are working perfectly. THANK you !

    Marking as solved.

+ 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. Count cells only if Countifs condition met
    By BernieDoc in forum Excel General
    Replies: 2
    Last Post: 08-28-2020, 09:14 AM
  2. How to count the number of cells before a condition is met?
    By svb08 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-28-2016, 07:46 PM
  3. Count cells that are equal with condition
    By ottoex in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-16-2013, 10:35 PM
  4. need help to count with condition on two consecutive cells
    By beyma in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-29-2012, 08:15 PM
  5. Count non-blank cells with condition
    By isabella in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-11-2010, 03:59 AM
  6. Count unequal cells with condition IF
    By troy_yy in forum Excel General
    Replies: 4
    Last Post: 04-26-2010, 07:28 AM
  7. Count cells with condition
    By Amanda in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-09-2005, 02: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