=SUM(SUMIFS(A:A, B:B, {"X","S"}, C:C, ">="&H1))
The above formula works fine. But I would like to be able to replace the {"X", "S"} with a cell reference so that I can manipulate the letters without editing formulas directly. Eg:
=SUM(SUMIFS(A:A, B:B, G1, C:C, ">="&H1)) where G1 contains {"X", "S"}.
Ideally, I would like to use a formula in G1 to change the list based on some conditions. I have no trouble coming up with the formula for G1, but the main formula won't accept it.
What am I doing wrong?
Bookmarks