Good morning everyone. I require some help with my spreadsheet.
As you will see by the screenshot below, i have added drop down boxes with text that i pick based on different combinations. I then have a value for each option that i wish to auto sum when i change the drop down box.
So far, countif and sumif have only enabled me to sum up each text induvidually (so each drop down menu that contains a text option selected will read as 1, instead of its preferred value)
I've read a few different threads on here explaining how people have got similar setups to work using sumif adding in each text option in qoutes and adding a value next to it in the formula, but the downside to this is if i wish to change the value of one of my text options (say for example changing small black from 1 to 4) i would then need to change the value in the formula on each seperate sum cell.
This spreadsheet is designed to test the balance of values for a scoring system, so ideally i need a fast easy workflow where i can constantly change the drop down menu combinations and their values on the fly and autosum takes care of the rest.
If there is such a workflow possible i would greatly appreciate your help on the matter.