Hi, I am using sumifs and my sumrange is a dopdown. How do we do that.
I understand that we can put multiple filters by sum criteria and use drop downs in sum criteria. But not sure how to use sum range in a drop down list.
e.g In a drop down list i have Orders, Cost, Revenue
Now if want to use it something like =sumifs(Orders,date_range,date,area_range,area)
Can i do this. If yes how?