xl-central.com, Your Quick Reference to Excel Solutions





navleft
navright
spacer
Sum the Largest 3 Values

Sum the Largest 3 Values

The following formula returns the sum of the largest 3 values from B2:B10...

=SUM(LARGE(B2:B10,{1,2,3}))

Based on the sample data, the formula returns 255.  Sample Workbook



spacer
Wu Yi Tea
Website Designed by Wu Yi Tea
Design downloaded from free website templates.
Wordpress Themes