How to split cell data from a drop down menu and add to another sheet to count totals

I have a sheet1 that staff from 3 locations uses to choose items they donated. in the drop-down item column, they can choose all the items they donated (in the same row). Ex: Merlin Ono from location TNP.

on a separate sheet, I need to calculate the totals for each item donated from the dropdown column by store.

so sheet 2 is totals donated

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!