Tried this one but still got the #DIV/0 (I did enter with control shift enter
on both)

"David Biddulph" wrote:

As an array formula (entered with Control Shift Enter)
=SUM(IF(ISERROR(K1:K11),"",K1:K11))/COUNT(K1:K11)
--
David Biddulph

"Meenie" wrote in message
...
I have Excel 2003
All I want to do is make a formula to show the Average of a range of cells
BUT some of the cells are have #DIV/0 (I don't have the numbers for those
right now) and I want to ignore those cells. I'm trying to do that with an
"if" formula, but can't seem to get it to come out right. I keep getting
?Name.