Large function & Sumif

Hello All,


I have a query related to functions & formula. Please find below mentioned question and

help me solve it. Thanks.

D E F
Division Month Revenue amount
North Jan 150
South Jan 220
East Feb 370
West Feb 200
North Feb 500
West Feb 400
South Mar 700
North Mar 150
East Apr 200
South Apr 500
North May 160



3 Summing top 'N' - A short question - but very difficult

Continuing with the preceding question. Find the total of the 'N' largest revenues in F7:F17. 'N' is selected in cell G55.


N largest revenues: 1 <- You can change this cell

As part of your solution you can use the LARGE function. This question is difficult because some of the revenues are the same: The largest revenue is 700. The next largest revenues are 500 and 500 again. So, for example, the total of the two largest revenues is 1,200 and not 1,700.



Total of N largest:

Where did the solutions you already tried go wrong....?