I have a formula in a cell as below
=SUMIFS(N:N,D:D,AE19,K:K,AD$19)
In cell A1, i want to have a drop-down list from JAN to DEC (all twelve months). Based on the month i select, i want the row "N:N" to change to a different value.
If A1 is Jan, then in SUMIFS should have N:N as range, if it is Feb, then the next column (O:O), for MAR it should be P:P...so on for all twelve months.
How to do this? also, can the solution you provide be used in other formulas as well? there are several other formula that use range N:N & i want all of them to change when the month is changed.
Thanks for your time in advance.
Bookmarks