Yup...it was 2 in my head...1 when I typed it (sheesh!)

Thanks

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


"T. Valko" wrote in message
...
Typo:

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

=TRIMMEAN(A1:A6,2/6)*12

--
Biff
Microsoft Excel MVP


"Ron Coderre" wrote in message
...
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