Forum Discussion

Copper Contributor

Nov 16, 2019

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?

Excel Formulas and Functions

2 Replies

Haytham Amairah
Silver Contributor
Nov 16, 2019
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}))
Haytham Amairah
Silver Contributor
Nov 16, 2019
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