Sumrange in a dropdowm during sumifs

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?

By: SM2

Leave a Reply

Your email address will not be published. Required fields are marked *