Count Items in Classes of Pairs

I have a spreadsheet with nearly 9000 records in it. There are two columns of data: 1) Separator Installed and 2) BMPs Followed. Each record has either Y or N for each item. I want to summarize Certi...

Formulas & Functions

Requests

Bryant Boyer
Oct 11, 2017
Hey Tom!

That's an interesting question. Hopefully I can help you out.

I'm thinking that SUMPRODUCT would be the best function to use here. Next to SYBY, I would enter

=SUMPRODUCT(($D$2:$D$8812="Y")*($E$2:$E$8812="Y"))

Similarly, I would enter the following next SYBN, SNBY, and SNBN respectively:

=SUMPRODUCT(($D$2:$D$8812="Y")*($E$2:$E$8812="N"))
=SUMPRODUCT(($D$2:$D$8812="N")*($E$2:$E$8812="Y"))
=SUMPRODUCT(($D$2:$D$8812="N")*($E$2:$E$8812="N"))

I think that should work for you. Let me know if it doesn't!