Forum Discussion
SUMIFS formula for a multiple select dropdown
Hi All, I'm working on a weekly spend report and I've used the VBA code (found in other discussions) to get a multiple select dropdown for countries. So I can now select Austria, Spain, Italy or Germ...
Hi Galina,
I see, that's in opposite way. When it could be
=SUMPRODUCT(ISNUMBER(SEARCH($D$2:$D$6,$A2))*$E$2:$E$6)
Amazing, thank you so much, Sergei!!
That has now worked for the multiple select dropdown.
My next step is to incorporate other dropdowns too (so one for multiple countries, and one for a week, one for activity). I am working on a sumifs and a sumproduct formula incorporating what you've given me. Is this something we've seen before?
Thanks
Galina
Hi Galina,
In general SUMPRODUCT shall work, you may add as many filters as you need.