Hello all,
I have a list of "weights" in column H. They can all be ranked from 1 to 30 (none are exactly the same). I want to write 1 formula that sums the top 10 (biggest) weights without having to make another column for "weight rank". I tried the following as an array formula, but it didn't work....
=SUMIF($H$3:$H$32,RANK($H$3:$H$32,$H$3:$H$32)&">=10")
Any ideas?
Thanks
Bookmarks