I need some help with with the LARGE formula.
I have a formula that works with Google Spreadsheets but when it is exported as Excel fails.
I need to take the sum of the 3 highest values of 6 values. This was done very easily in Google Docs using the following formula
=SUM(LARGE({L7,O7,AP7,AS7,BK7,BU7},{1,2,3}))
The excel LARGE formula seems to choke on not having a range as the first parameter. I would love to be able to do this without creating a second sheet and moving all the cells to adjacent values, is there a way to make {L7,O7,AP7,AS7} into a parameter that large will accept?
Bookmarks