Excel How to count from a column if specific condition in another column is true
- Thread starter Tahir M
- Start date
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.
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.