Sum a certain number of cells

Hi all

I'm working on a spreadsheet where I would like to be able to be able to sum a certain number of cells automatically. E.g. I put in 120 or 100 in my reference cell and Excel then gives me the sum of the top 120 or 100 cells in my revenue column. Is there a way to do this? I've thought about simply naming the range of cells like "top120revenue" and "top100revenue" etc. but besides being static it is also complicated when working with 27 sheets. With a macro I expect it would simply be a matter of changing sheet reference and formula name in the macro once per sheet instead of once per interval per sheet

Hope someone can help!?

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

Thank you for the update. However, this is a duplicate post and as such does not comply with Rule 5 of our forum rules.

Thread Closed.