Excel Forum
Similar Content
Calculate Percent Change in Excel
Tutorial: How to calculate the percentage amount that a value has changed in Excel. This includes q...
OFFSET Function in Excel
Tutorial: The OFFSET function in Excel returns a cell or range reference that is a specified number...
Excel VBA Check if a Cell is in a Range
Tutorial: VBA that checks if a cell is in a range, named range, or any kind of range, in Excel. Sec...



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.