Spreadsheet Formulas

Excel VBA
Excel Formulas
User-defined Functions
Office Links
Access VBA
Access SQL
Alan’s Excel FAQ
Excel Home
Alan’s Home

Average with an IF Statement


{=AVERAGE(IF(C4:C50,C4:C5,""))}


© 2002-2010

Updated:  05/27/2010 19:26
This page added:  01 May 2002