|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.