Thread
:
ignore #n/a
View Single Post
#
1
Posted to microsoft.public.excel.misc
GENO
external usenet poster
Posts: 17
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
Reply With Quote
GENO
View Public Profile
Find all posts by GENO