Ranking based on sumif

[drewbrown03]

Does anyone know how to rank data based on a sumif formula?

I have a spreadsheet that has monthly revenue for a number of accounts. I want to rank the accounts based on the sum of their monthly revenue. Is there anyway to do this with one formula?

 

[jbeaucaire]

I would never recommend this. You should collect the SUMS for the various months in a Pivot Table or a manually designed Summary section. Then a normal simple RANK() on those sums works well and is easy to maintain.

 

[T. Valko]

Does anyone know how to rank data based on a sumif formula?

I have a spreadsheet that has monthly revenue for a number of accounts. I want to rank the accounts based on the sum of their monthly revenue. Is there anyway to do this with one formula?

Can you post some sample data and let us know what result(s) you expect?