Thread: formula to throw out high number and low number
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
  
Posts: 524
Default formula to throw out high number and low number
Sat, 15 Sep 2007 10:48:01 -0700 from Deb
:
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

Assuming they're in A1:A6,

=3*(sum(A1:A6)-min(A1:A6)-max(A1:A6))

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/
Reply With QuoteReply With Quote