Excel Drop Down List value used in if statement to calculate totals Dynamically (on the fly)

Hi I am creating a simple Entrepreneurship Aptitude for characteristics you should have and also questions, each with true and false or small answers. The questions are written in a drop down list and the answers (yes, no, maybe, etc) are also in a drop down list.

What I would like to know is how do you use an if statement that would be like:

=if( DropDownItemTwo at B3 == 'yes' at C3) { add 1 to the total } 

I attached a picture so you can see my drop down list and page structure. Beside Question on the right under 'Results' it should add to the total in the blank spot beside it ( hopefully dynamically so the user sees it updating ). This would also happen beside the characteristics title under 'Results'.

Thank you for taking time for viewing my question and possibly answering it, I look forward to knowing how to do this if it is even possible.