Forum Discussion
Solved
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...
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!
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!
Excellent solution!
Worked perfectly!