formula to throw out high number and low number
A few keystrokes shorter:
=SUM(SMALL(A1:A6,{2,3,4,5}))*3
--
Biff
Microsoft Excel MVP
"T. Valko" wrote in message
...
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
|