tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,825
- Office Version
- 365
- 2019
- Platform
- Windows
I have two columns of data in columns A and B.
Column A consists of 1s and 2s, column B random numbers.
In cell F6, I have this formula:
How can I make this part of the formula:
refer to a range of cells?
For example, if I want to change the criteria to 5 and 6, obviously I can change it in the formula itself but instead I would like to change it in some other cell.
Thanks
Column A consists of 1s and 2s, column B random numbers.
In cell F6, I have this formula:
Code:
=(SUM(SUMIFS(B:B,A:A,{"1","2"})))
How can I make this part of the formula:
Code:
{"1", "2"}
refer to a range of cells?
For example, if I want to change the criteria to 5 and 6, obviously I can change it in the formula itself but instead I would like to change it in some other cell.
Thanks
Last edited: