Adding total to another work sheet.

In Excel everytime a question in column b of work sheet 2018 swim is answered yes i need that yes to be added as a number value to another worksheet to get a total.
Example: Member is in duplicate program. If yes I need the yes to be added as a number value under member sheet. So if I have three members that say yes I need those yeses to be placed as three under member sheet in the column that says Total Members that are in duplicate program. Every time a member answers yes it continues to add to get a total in that column.