I have a table 6 coluns x 20 rows and need to sum the highest 3 or 4 or 5 values in each column without resorting the table. I have tried copying the data then sorting the data but that has not worked.

re: " need to sum the highest 3 or 4 or 5 values in each column"What do you mean by "

3 or 4 or 5"?Will you making that choice each time you want a SUM? How will you tell Excel how many values to SUM?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do older people you know use the Internet?

Discuss in The Lounge

Poll History