count errors
=COUNTIF(A1:A100,#N/A)
"stef" wrote:
XL 2002 SP3
Win XP HE SP1
Follow-up to: microsoft.public.excel
How do I count errors #N/A in column A that has both errors and proper
values in some of its rows?
I am trying a countif but struggling w/ the error part e.g. isna or
iserror, etc.
tx.
|