Countif with two criterias
Thanks Bob
"Bob Phillips" escreveu:
If you have Excel 2007, you can use
=COUNTIFS(A2:A20,"Joe",B2:B20,"Yes")
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"Ricardo" wrote in message
...
Hi all
I need your help. i need to use the countif but with two criterias ...
something like the sumproduct and the sum if.
Example:
Col. A Col. B
Joe Yes
John No
John No
Joe Yes
Joe No
I need to count how many Joe with Yes I have.
Thanks,
|