aryanaveen
Board Regular
- Joined
- Jan 5, 2015
- Messages
- 104
Hi All,
I am looking for a formula where I can count based on 2 criteria.
Example
<tbody>
</tbody>
In the above table I want to count number of "A" in range "C1:H5" where Column B is having "Naveen". Please note "Naveen" can be in any row under column B.
Please help
I am looking for a formula where I can count based on 2 criteria.
Example
A | B | C | D | E | F | G | H |
1 | Naveen | A | B | A | A | C | D |
2 | Praveen | C | D | f | f | f | f |
3 | Abhay | d | d | g | g | g | f |
4 | Prakash | d | f | i | a | i | a |
5 | Giri | d | j | f | j | k | a |
<tbody>
</tbody>
In the above table I want to count number of "A" in range "C1:H5" where Column B is having "Naveen". Please note "Naveen" can be in any row under column B.
Please help