Excel How to count from a column if specific condition in another column is true


Joined
Apr 25, 2017
Messages
5
Reaction score
1
Hi guys!

I want to count number of T's and number of O's in column "C" (image attached) only if the value in column "AE" is "Open".
I have tried different IF conditions with COUNTIF but its not working that I tried.

Any solution guys ?

Regards,
Tahir
 

Attachments

  • to b sent.PNG
    to b sent.PNG
    4.1 KB · Views: 102
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
Welcome to the forum @Tahir M :)

As you have multiple criteria, you need to use the COUNTIFS function instead.

It works like this: =COUNTIFS(range1,critera1,range2,critera2)

So your formula might look something like this:

=COUNTIFS(C:C,"T",AE:AE,"Open")

Just replace the "T" with "O" to count the Os.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top