Thread: ignore #n/a
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GENO GENO is offline
external usenet poster
 
Posts: 17
Default ignore #n/a

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