thanks for all of the quick responses

the countif function only lets you put in one column for criteria, not 2.

the only sollution i had managed before was changing the Yes/No to 1/0 as cobere suggested. i think ill just do this for now.