Hi guys,
Capture.JPG
basically I was wondering if there was a way that I could make the formula (which is just sum) add, but add separately for each option in a drop down?
for example, if i select "a" in the drop down, i can input everything I need and the total will be calculated.
then, I can select "b" from the drop down, and all the cells revert back to zero, and only the total of what i input in b will be calculated.
so when I go back to "a" only a's input and total are there, and when i go to "b", only b's input and total are there?
Bookmarks