Your formula works as long as it is array-entered. Are you sure
you've array entered it? What result do you get?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"PA" wrote in message
...
I recall reading this and now cant find it.
A column of data with numerical values, some empty cells and
some with zero's.
I need to calculate the average, but supress cells with zeros
from the
calculation.

I tried =IF((A1:A44)<0,AVERAGE(A1:A44)) arrayed entered,
but no go.

Suggestions welcomed, and my thanks.
Paul