Forum Discussion
adding certain filtered numbers
if i have filtered 5 top numbers - eg 3,3.3,2,2,4,4,4,5 but i only want to add the 5 numbers that have the highest value - 5+4+4+4+3 - how do i do that in excel?
Hi,
Try this formula:
=SUM(LARGE(A1:A8,{1,2,3,4,5}))
But please note that the fifth highest value is 3.3, not 3.
Regards