program formula to ignore any cell displaying "N/A"

[Ed P]

I have built a complicated workbook that pulls from
individual worksheets. I am searching for a way to build
a formula that will calculate a range of cells. That
range consists of some that are used and some that are
not. The ones that are not used are displaying "N/A" as a
result of the formula build.
Can anyone tell me how to build a formula and or function
formula that can calculate the range using only the cells
with a value in them. That range will remain constant but
the cells will change from "N/A" to a value each time it
is used.
Thanks for your help
Ed P

 

[Cecilkumara Fernando]

Ed P,
My Test range is P212
to sum
=SUMIF(P212,"<>#N/A")
to count
=COUNTIF(P212,"<>#N/A")
and array formulas (hit Enter while keeping Ctrl and Shift keys down)
=AVERAGE(IF(ISERROR(P212),"",P212))
=MAX(IF(ISERROR(P211),"",P211))
HTH
Cecil