Formula Help

Greetings- I'm struggling with the cross-sheet referencing and need some help with a formula. I want to create a new sheet summarizing the values on a corresponding dropdown menu for the name and # of products we sell. I'd like the total number sold for each dropdown choice displayed on the new sheet.

In the screenshot, the columns I want summarized are "Module Type" and "# of Modules" so we could know we have sold (for example) 273 REC 320 NPs or 46 Silfab SLA310Ms. Do I have to create a formula for each value in the dropdown list? Thanks for the help.

smartsheet help.JPG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!