sum up values in a different columns if another dropdown column contains the required values

Tadiwa
Tadiwa โœญโœญโœญ

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.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!