Hi all, I'm trying to calculate the top 10 numbers from across 3 sheets.
I have the following formula on one of my sheets but it's only calculating the top 10 of that sheet in the cell range. I want to get the top ten from across the sheets (not the top 10 in each sheet)...is this possible? If it helps, the range would be the same across all three sheets - W3:W27.
Current formula: =SUM(LARGE(W3:W27,{1,2,3,4,5,6,7,8,9,10}))
Bookmarks