Keep count of what is selected in drop down list

[JustinG]

Hello everyone, I hope you can help. I am by no means excellent in Excel but I am working on a side project.

My goal is to keep a running count of how many times a selection is made from a drop down list.
The drop down list will have Yes or No and depending on what is selected it will add a 1 to the count column next to what was selected

ex.
User 1 picks No, a 1 will show in D3
User 2 picks No, a 2 will show in D3
and so forth

At this point I am not sure what function to use.

Thank you for taking a look.

 

[bebo021999]

Worksheet function can not, but VBA code.
Tell me if you are ready for VBA solution.

 

[JustinG]

Worksheet function can not, but VBA code.
Tell me if you are ready for VBA solution.

Thank you for the reply, I think VBA is a little out of my knowledge zone and would hate to waste your time. I will do some research and see if I can find another way to go about my work. Or learn about VBA. Feel free to leave a solution, If I figure out VBA I will surely use it. Id understand if you don't though. Thanks again.

 

[bebo021999]

Worksheet function can not save the history. It always return current data from a cell.
But in VBA, there is worksheet_change even, it can fire any change in a range.