In need of a formula to rank highest to lowest

Hi,

I have two sheets, one that contains my data and the other contains what I'm trying to summarize. Example:

Active Non Active Active Active
store1 store2 store3 store4
Fee 1 500 600 780 320
Fee 2 800 400 1000 130
Fee 3 150 360 600 500

What I am trying to do on my summary sheet is add the fees for each active store and have it return the values from largest to smallest. The formula I have so far gets me the max value but I'm not sure where to go from there. {=max(if(sheet1$B$1:$E$1="Active",sheet1$B$3:$E$3+sheet1$B$4:$E$4+sheet1$B$5:$E$5))}. Would you be able to tell me if this is correct and how I can get the next value? Is there maybe an easier way to do this?

Thanks!

Could you post some example data with your expected results created manually?

This is what I would like for it to do. On my summary sheet it ranks the active stores from highest to lowest on total fees.


Active Non Active Active Active
store1 store2 store3 store4
Fee 1 500 600 780 320
Fee 2 800 400 1000 130
Fee 3 150 360 600 500

Output:

Rank Store Total fees
1 store3 2380
2 store1 1450
3 store4 950

Pl see attached file.