I have a row of 33 numbers (G4:AM4) and need to sum the highest 22 numbers in that range. I do not think RANK will work as some of the numbers are the same value and I need the highest 22 values.

I have tried

=SUM(LARGE(G4:AM4,ROW(INDIRECT("1:22")

and also

=SUM(IF(COUNT(G4:Z4)<10,G4:Z4,LARGE(G4:Z4,{1,2,3,4,5,6,7,8,9,10})))

Thanks

Bev