My spreadsheet, i have cells which have a drop down box we different option for example Option 1, Option 2, Option 3.

Is it possible for me to have 3 seperate cells as SUMS, and when i select an option it adds to the total for that option

if i choose option 1, it adds 1 to the total


if i change it to option 2, then it takes off 1 from option 1 total, and adds 1 to the option 2 total

hope this makes sense