=SUM(IF(ISNA(I32:I53),"",I32:I53))/(COUNT(I32:I53)-COUNTIF(I32:I53,0))
as an array formula (Control Shift Enter)
--
David Biddulph

"GENO" wrote in message
...
Hi

I would like to ignore cells which reflect #n/a and consider cells with a
value from 0 .... , here is my current formula
"=SUM(I32:I53)/(COUNT(I32:I53)-COUNTIF(I32:I53,0)) "

i currently have a formula in cells i32:i53.

thanx