No need.... blank cells and text does not effect an average formula, as it
stands it will average values below and above 0 but not 0.

HTH
Jean-Guy

"Tammy" wrote:

pinmaster -
how would i modify that statement to EXCLUDE blank cells but include 0 ?
tammy


"pinmaster" wrote:

Hi,

=AVERAGE(IF(A1:A100<0,A1:A100))
enter using Ctrl+Shift+Enter

Cheers!
Jean-Guy

"latripl" wrote:

I am trying to do a formula for averaging a series of numbers (which I can
do) exept if there is zero in the series I want to ignore it in the avg. How
do I write an IF statement for this?