SUM(COLLECT/SUMIFS( based on multi-select

Hi everyone,

Does anyone have a formula already handy that does this? Looking to SUMIFS values where the variable is one of the options in the dropdown value?

This is a cross sheet formula pulling from a table where there is only one country per cell, but looking to aggregate (show me everything in this region).


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!