Hi you were on the right track with LARGE bbut you need an array formula like this
lets say your data is on row 3 from column A to L and you want to calculate the top 7 amounts then this will do it paste this formula in to any cell outside of your data range change the A3:L3 to be your range of data, the list of figures you see i.e 1 - 7 thats where you set the amount of top figures you want to calculate,.....anyway once you have changed what you need before you leave the cell you must press and hold Ctrl, Shift and then press enter, now let go of the other buttons, the action you have just performed is to create an array formula. You can substitute the word LARGE for SMALL if you wanted the lowest figures, anyway have a play around with it!
Regards,
SImon
Bookmarks