ignore #n/a

  • Thread starter Thread starter GENO
  • Start date Start date
G

GENO

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
 
=SUM(IF(ISNA(I32:I53),"",I32:I53))/(COUNT(I32:I53)-COUNTIF(I32:I53,0))
as an array formula (Control Shift Enter)
 
Try
=SUMIF(I32:I53,"<>#N/A")/(COUNT(I32:I53)-COUNTIF(I32:I53,0))

If this post helps click Yes
 
Back
Top