Counting Values in A Column Mixed with #N/A

[rwmill]

I need to count data in a column that is mixed with #N/A, and I get answers of #N/A. Is there a way around this? Note, I need to use =NA() in blank cells, instead of ="" for purposes of plotting in a chart.

Thanks,

Ric

[Tony Valko]

Maybe this...

=COUNTIF(A1:A10,"<>#N/A")

That will count empty cells.

If that doesn't give you the result you expect provide more detailed info.

[rwmill]

Thanks, Tony, that worked fine.

[Tony Valko]

You're welcome. Thanks for the feedback!