|re: "please excuse my minimal excel knowledge here"|
This has nothing to do with your level of Excel knowledge...it has to do with the proper way to post a question in a help forum.
I'll repeat what I said in my previous response:
Keep in mind that we can not see your spreadsheet from where we're sitting, so you have to be specific about what you are trying to do.
You've given us a little more information, but you still haven't given us enough detail to be able to help you.
re: "each time i either select "on" or "off" a value is added/subtracted in a totals cell at the bottom of each column"
"a value"? What value?
re: "if i change on to off, the cell value is reduced"
So, is that what you want it to do or not to do?
You still haven't explained what you are trying to do. You haven't posted the formulas you are using or provided any information as to how the selection of the Drop Down choices impacts the "total cells".
Until you supply enough detail,we can't help you.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.