Average Formula Help

[excel_training_wheels]

Hi--

Anyone have a suggestion on how to calculate an average if the column currently is populated with the following? Column A has months, column B has numbers

Column A/B
Jan 32.4
Feb 21.8
Mar 19.7
Apr 51.6
May #DIV/0!
Jun #DIV/0!

There are formulas in the cells in column B which are calculating the numbers above... may and june return an error (which is ok...) I just want the average where the cell value does not equal #DIV/0!.

 

[barry houdini]

Try either

=SUMIF(B1:B6,"<>#DIV/0!")/COUNTIF(B1:B6,"<>#DIV/0!")

or

=AVERAGE(IF(ISNUMBER(B1:B6),B1:B6))

confirmed with CTRL+SHIFT+ENTER

 

[excel_training_wheels]

Beautiful... the ISNUMBER function works great for me here.

Thanks!