One way

=SUM(A2:M2)-SUM(SMALL(A2:M2,{1,2}))


--


Regards,


Peo Sjoblom


"Karen53" wrote in message
...
I am trying to find a function that will add a series of numbers LESS the 2
lowest numbers in the seqeunce. They are not in order from lowest to
smallest
as there is more than one group and it is sorted by date.

Example:

172 172 172 180 169 180 163 180 175 165 180 175 180

I would need it to pull out the 163 & 165 and add the rest. These numbers
will be different for each row and the lowest are not always in the same
column. Any ideas??

thanks!

Karen