Count # of #N/A

[GeneralShamu]

Does anyone know how I can do this?

Say I have:
3
8
5
3
21
#N/A
2
34
5
#N/A

what can I do? I tried =countna(A1:A10) but it doesn't exist, must I use countif?

 

[Ron Coderre]

I think the formula you need will amuse you:
Try this:

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

Does that help?

 

[Aladin Akyurek]

In case of a multilangual usage...

=COUNTIF(A1:A10,NA())

 

[GeneralShamu]

Yes, thank you. I did not know you could treat the error message as a string.

 

[scottylad2]

Excel Workbook
	L	M	N	O	P
29
30
31		#N/A		#N/A
32		#VALUE!		3
33		5
34		4
35		#N/A
36		8
37		8
38		5
39		4
40		#N/A
41		8
42		8
43
44		=COUNTIF(M31:M42,O31)
Sheet3

Is it the nA your trying to count? if so then use countif

 

[scottylad2]

ignore the sumproduct reference, it's from another query