I have created the following excel file and I want to extract only the column A that contains 2024/01 and 2024/02 and add the column B.

| Column A | Column B |Column C |
1| ——– | ——– |——– |
2| 2024/01 　| 110000 |2024/01 |
3| 2024/02 　| 120000 |2024/02 |

So I entered the following formula using {}.
=SUMIFS(B:B,A:A,{“2024/01″,”2024/02”})
This is successful.

However, if I enter 2024/01,2024/02 in column C and enter the following formula, I get an error.
=SUMIFS(B:B,A:A,{C:C})
How should I deal with the calculation referring to the cells in column C?

I tried to enter the following formula, but it said “spill”.

=SUMIFS(B:B,A:A,CHOOSE({1,2},C1,C2)