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,
You may use something like
=SUMPRODUCT(ISNUMBER(SEARCH(<country name>,<countries column>))*<values column>)
Hi Sergei, thank you so much for getting back to me!
The formula returned a #value! and I think it's because the multiple select dropdown results in a list where the countries are separated by a comma (country 1, country 2, country 3 etc) within the same cell, so it is not finding it in the country column.
Is there a formula that can look at a list of items and return 1 if in a column, or 0 if not? I think this would make the SUMPRODUCT work