Hiya!
Was looking for some help with building a sumif formula with multiple or criteria, which uses cell references to define the or criteria.
In Tab 2 column A, I have a formula creating a unique dynamic range (which has the possibility to list up to 100 values), so I obviously don't want to use sumif with 1 cell reference + sumif with 1 cell reference + etc etc.
What would be ideal would basically be:
SUMIF(CriteriaRange, Criteria, SumRange)
SUMIF(Tab1B:B, Tab2A:A, Tab1I:I)
But I'm aware the sumif can't handle multiple or criteria using cell references natively.
I've seen some suggestions to use sumproduct as below;
SUMPRODUCT(SUMIF(Tab1B:B, Tab2A:A ,Tab1I:I))
But that is evaluating to 0, so assuming I'm not using it correctly or that's a dead-end?
Many thanks for any advice.
Bookmarks