title: How to get 0 to display instead of #DIV/0 in Excel 2010
body: <p>I am a novice at Excel and need some help with a formula.  I have a set of cells that are the sum of a formula. They are based on information from month to month. At times this can be zero. I want to average them out and am using this formula =AVERAGE(IF(F17:Q17&lt;>0, F17:Q17,"")). That works fine. But, I want it to display 0 if there are no values other than 0, instead it shows #DIV/0! Any ideas?</p>