Imran Azam
Board Regular
- Joined
- Mar 15, 2011
- Messages
- 103
Hi Guys
I have the below data , i am trying to do a formula that would count the number of "open" status the Manager "roy" has.
i tried a countifs but could get it right
can any one provide any help?
<tbody>
</tbody>
Thank you in advance
I have the below data , i am trying to do a formula that would count the number of "open" status the Manager "roy" has.
i tried a countifs but could get it right
can any one provide any help?
A | B | C | D | |
1 | name | manager | id | status |
2 | james | roy | 1 | open |
3 | jack | roy | 1 | closed |
4 | alex | Ian | 1 | open |
5 | jack | roy | 1 | open |
6 | jones | Ian | 1 | open |
<tbody>
</tbody>
Thank you in advance