Try this:

=SUM(A1:A6,-MIN(A1:A6),-MAX(A1:A6))*3

--
Biff
Microsoft Excel MVP


"Deb" wrote in message
...
I have 6 months of actuals and I need to throw out the month and the low
month then take the remain 4 months times 3 to come up with a years total