Function to compute average without high and low values

   =(SUM(region)-MAX(region)-MIN(region))/(COUNT(region)-2)
				

   Function HiLoAverage(region) As Variant
      With Application
         HiLoAverage = (.Sum(region) - .Max(region) - .Min(region)) / _
            (.Count(region) - 2)
      End With
   End Function
				

REFERENCES

"Visual Basic Language Reference," version 3.0, page 231

"Visual Basic User's Guide," version 5.0, pages 50-51

Microsoft Excel 97 and Microsoft Excel 98

For more information about using custom functions, click the Index tab/button in Microsoft Excel 97 Help or MS Excel Help, type the following text and then double-click the selected text to go to the "About user-defined functions" topic.

Microsoft Excel 7.0

For more information about using custom functions, click the Index tab in Microsoft Excel 7.0 Help, type the following text and then double-click the selected text to go to the "Writing a user- defined worksheet function" topic.

Microsoft Excel 5.0 for Windows and Macintosh

For more information about using custom functions, click the Search button in Help, and type: Click the Show Topics button, select the topic "Overview of Creating a User-Defined Function", and click Go To.