Sum a certain number of cells

[Dennis Foldager]

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!?