Hi
Try this =SUMPRODUCT((A1:A9=8)*(B1:B9="yes"))
HTH
John
"Question??" wrote in message
...
I am looking for something similar. I have 2 columns that I need to count

A B
8 Yes
2 Yes
6 No
4 Yes

I need to count the number of Yes's in column B for each number, so lets say
I need the number of Yes's for 8. How can I do that? Is it even possible? I
tried using countif but I can only get it to use just the one column and I
need it to filter both.

Thanks for your help!