Excel Formula: How to loop through an array and check if part of another list

I am wondering if it is possible - using an Excel formula (no vba) - to loop through a list with values and check if those values are in another list. The idea is to use this to come up with a sum pulling data from the first list while the second list sets the conditions. Please see below picture. I was thinking that this might work with sumproduct including an if-statement. Any ideas?

example_visualized



Read more here: https://stackoverflow.com/questions/67388542/excel-formula-how-to-loop-through-an-array-and-check-if-part-of-another-list

Content Attribution

This content was originally published by user3601876 at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: