SUMIFS with "OR" Condition

[hahdawg]

Hi

I understand that if I want to do sumifs with an "or" condition, I do something like

=SUM(SUMIFS(A:A,B:B, {"Condition1", Condition2"}))

I have a lot of conditions, so I'm wondering whether there's any way I can read the the conditions from cells on a worksheet, so I don't have to type them in manually. In other words, I'd like to have the things inside the "{ }" be cell refrences.

 

[NBVC]

Try something like:

=SUMPRODUCT(SUMIFS(A:A,B:B,$K$2:$K$9))

where K2:K9 contains the list of conditions.

 

[Colin Legg]

If they're all mutually exlcusive 'or' conditions in the same column then I think you can do it with SUMIF.

=SUMPRODUCT(SUMIF(B:B,$K$2:$K$9,A:A))

 

[hahdawg]

Awesome. Thanks!