How can I count #N/A in a column? TIA, Rasoul Khoshravan
D Domenic Dec 20, 2004 #2 Rasoul Khoshravan Azar said: How can I count #N/A in a column? TIA, Rasoul Khoshravan Click to expand... Try... =COUNTIF(A1:A10,#N/A) Hope this helps!
Rasoul Khoshravan Azar said: How can I count #N/A in a column? TIA, Rasoul Khoshravan Click to expand... Try... =COUNTIF(A1:A10,#N/A) Hope this helps!
D Daniel.M Dec 20, 2004 #3 Hi, This array formula (Ctrl-Shift-Enter) =SUM(--ISNA(A1:A100)) Notice you can't choose ALL the column. Use a range instead. Regards, Daniel M.
Hi, This array formula (Ctrl-Shift-Enter) =SUM(--ISNA(A1:A100)) Notice you can't choose ALL the column. Use a range instead. Regards, Daniel M.
