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.
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.