Try this:
=TRIMMEAN(A1:A6,1/6)*12

TRIMMEAN (as used above) removes the highest and lowest values from the
range and averages the remaining values.

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)





"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