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)
Tsukasa Watanabe is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.