Hello:

I am using the below formula and i want to see if it is possible to pass variable in the formula to give the result.

=SUMIFS(DailySales!$N$2:$N$2000,DailySales!$B$2:$B$2000,">="&$J7,DailySales!$B$2:$B$2000,"<="&$K7,DailySales!$A$2:$A$2000,L$1)
N$2:$N$2000 needs to be variable.
The value of variable can come from cell K1
Example:
If K1 = N then the above formula will stay as is.
If K1 = M then above formula needs to change to :

=SUMIFS(DailySales!$M$2:$M$2000,DailySales!$B$2:$B$2000,">="&$J7,DailySales!$B$2:$B$2000,"<="&$K7,DailySales!$A$2:$A$2000,L$1)
I hope this is clear explanation.

Please help and let me know if any questions.

Thanks
Riz