Mahmud,

To sum the largest values, use

=SUM(LARGE(A1:A10,{1,2,3,4,5,6}))

To sum the smallest values, use

=SUM(SMALL(A1:A10,{1,2,3,4,5,6}))

--

Cordially,

Chip Pearson

Microsoft MVP - Excel

Pearson Software Consulting, LLC

Quote:

> I have 10 data in A1:A10 . Now I want to sum the highest/lowest

6 data from

> these data. How can I do this in Excel?