I need help creating a formula that will do a SUMIFS depending on the value in a cell. I have data that is broken into different worksheets dependent on month and they are all named in the same manner - 2020 January Dump - 2020 February Dump ...etc. I need a formula that will change depending on what month it says in cell k3. so for instance if k3=February, I need the formula to look in 2020 February Dump rather than 2020 January dump.
Bookmarks