Attached is an Excel Spreadsheet that uses Averageifs to calculate the BLM averages for a '7427 $OD, $31, $OE, and $E6. This spreadsheet is to help experienced Excel users learn the Averageifs formulas.
http://spreadsheets.about.com/od/som...s-tutorial.htm
dave w