'7427 VE Correction using Excel Averageifs $OD, $31, $OE, and $E6 [Archive]

View Full Version : '7427 VE Correction using Excel Averageifs $OD, $31, $OE, and $E6

dave w

07-21-2014, 04:23 PM

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/somethingiffunctions/ss/2011-04-05-Excel-2010-averageifs-function-sbs-tutorial.htm

dave w