Excel Forum

Excel Magic Trick #145 p3 AVERAGE IF before 2007 Excel

AVERAGEIF or AVERAGE IF, for Excel 2003, 2002, 2000, 1998, 1997 see how to create a formula that will calculate the average when you have more than 1 criterion. See the AVERAGE and IF functions. AVERAGE for more than one criteria.
Excel Statistics
Average with more than one criterion criteria
Excel 2003 Excel 2002 Excel 2000 Excel 1998 Excel 1997

Pivot Table Average if.

Got a Question? Ask it Here in the Forum.