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

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History