adding certain filtered numbers

[left_wing]

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?

[#2]

@left_wing

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

[#3]

@left_wing

If the range you're targeting is filtered out, try this one instead:

=SUM(AGGREGATE(14,7,A4:A14,{1,2,3,4,5}))