Hi all!
I'm not great with formulas so I was looking for some help on this. I have a table (call it table1) and I have a cell that has a formula that references the sales columns within the table (because of the way the sales work, there are multiple sales columns, lets call them "Sales Total", "Sales 1", "Sales 2", and "Sales 3". I have a cell (D4) on my worksheet that allows the user to choose "All", "1", "2", or "3". Right now, the formula I have uses a long SUMIFS statement, basically checking that if the uses chooses "1", then sum from "Sales 1", etc. Is there a way to make this formula shorter and somehow use the text from D4 (the user chosen value) to reference the column? ie: "Sales " & D4 or something? Thanks
I'm not great with formulas so I was looking for some help on this. I have a table (call it table1) and I have a cell that has a formula that references the sales columns within the table (because of the way the sales work, there are multiple sales columns, lets call them "Sales Total", "Sales 1", "Sales 2", and "Sales 3". I have a cell (D4) on my worksheet that allows the user to choose "All", "1", "2", or "3". Right now, the formula I have uses a long SUMIFS statement, basically checking that if the uses chooses "1", then sum from "Sales 1", etc. Is there a way to make this formula shorter and somehow use the text from D4 (the user chosen value) to reference the column? ie: "Sales " & D4 or something? Thanks