SUM(COLLECT/SUMIFS( based on multi-select
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).
Help Article Resources
Check out the Formula Handbook template!