sum up values in a different columns if another dropdown column contains the required values
I have a dropdown column that contains these values, A1-A9, B1-B9, C1-C9, D1-D9, E1-E9,S1-S9. These values represent the number of people, I can have a cell in the column with value A1, C1 &D3. I also have 6 columns that calculate the decimals I need.
Now I want to be able to check the dropdown column and add the values. I have A&B as the category apples, C&D as category banana , E$S as category mango. I want a metric sheet that will add the values in the 6 columns if the dropdown cell have values according to the fruits. If say it contains D&E , I would love to categorize that as MIX.
Any help will be appreciated.
Help Article Resources
Check out the Formula Handbook template!