Counting cells that do not contain N/A
 

Please could someone provide me with a formula that would allow me to count
the number of cells that do not contain N/A as an entry.

Thanks
Adam

Counting cells that do not contain N/A
 

=SUMIF(G1:G11,"<#N/A",G1:G11)

But it is FAR better to deal with the #N/A error at source:

=IF(ISNA(<your formula),"",<your formula)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Adam" wrote in message
...
Please could someone provide me with a formula that would allow me to
count
the number of cells that do not contain N/A as an entry.

Thanks
Adam

Counting cells that do not contain N/A
 

If N/A has been typed in (rather than the error #N/A), then try this:

=COUNTIF(A1:A100,"<N/A")

Hope this helps.

Pete

On Oct 29, 10:41 am, Adam wrote:
Please could someone provide me with a formula that would allow me to count
the number of cells that do not contain N/A as an entry.

Thanks
Adam

Counting cells that do not contain N/A
 

Hello Adam
=COUNTIF(A1:1500,"<#N/A")

HTH

Cordially
Pascal

"Adam" a écrit dans le message de news:
...
Please could someone provide me with a formula that would allow me to
count
the number of cells that do not contain N/A as an entry.

Thanks
Adam

Counting cells that do not contain N/A
 

Pete,

If N/A was typed in and thus text, wouldn't SUM() ignore it anyway?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Pete_UK" wrote in message
oups.com...
If N/A has been typed in (rather than the error #N/A), then try this:

=COUNTIF(A1:A100,"<N/A")

Hope this helps.

Pete

On Oct 29, 10:41 am, Adam wrote:
Please could someone provide me with a formula that would allow me to
count
the number of cells that do not contain N/A as an entry.

Thanks
Adam

Counting cells that do not contain N/A
 

I think papou meant:

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"papou" wrote in message
...
Hello Adam
=COUNTIF(A1:1500,"<#N/A")

HTH

Cordially
Pascal

"Adam" a écrit dans le message de news:
...
Please could someone provide me with a formula that would allow me to
count
the number of cells that do not contain N/A as an entry.

Thanks
Adam

Counting cells that do not contain N/A
 

Hi Sandy,

the OP was asking about count - if he used COUNT and the values were
numbers then this would ignore it (and he wouldn't have the problem),
so I assumed they must be text values and he was using COUNTA. I was
also making the distinction between #N/A and N/A, so the OP could put
in the appropriate one if he really meant #N/A.

There's a bit of logic to my posts now and then !! <bg

Pete

On Oct 29, 10:57 am, "Sandy Mann" wrote:
Pete,

If N/A was typed in and thus text, wouldn't SUM() ignore it anyway?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"Pete_UK" wrote in message

oups.com...



If N/A has been typed in (rather than the error #N/A), then try this:

=COUNTIF(A1:A100,"<N/A")

Hope this helps.

Pete

On Oct 29, 10:41 am, Adam wrote:
Please could someone provide me with a formula that would allow me to
count
the number of cells that do not contain N/A as an entry.

Thanks
Adam- Hide quoted text -

- Show quoted text -

Counting cells that do not contain N/A
 

Sorry Pete,

Not only did I misread your post,I misread the OP's post as well A double
goof!

My apologies to you both.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Pete_UK" wrote in message
oups.com...
Hi Sandy,

the OP was asking about count - if he used COUNT and the values were
numbers then this would ignore it (and he wouldn't have the problem),
so I assumed they must be text values and he was using COUNTA. I was
also making the distinction between #N/A and N/A, so the OP could put
in the appropriate one if he really meant #N/A.

There's a bit of logic to my posts now and then !! <bg

Pete

On Oct 29, 10:57 am, "Sandy Mann" wrote:
Pete,

If N/A was typed in and thus text, wouldn't SUM() ignore it anyway?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"Pete_UK" wrote in message

oups.com...



If N/A has been typed in (rather than the error #N/A), then try this:

=COUNTIF(A1:A100,"<N/A")

Hope this helps.

Pete

On Oct 29, 10:41 am, Adam wrote:
Please could someone provide me with a formula that would allow me to
count
the number of cells that do not contain N/A as an entry.

Thanks
Adam- Hide quoted text -

- Show quoted text -

Counting cells that do not contain N/A
 

Hello Sandy

Yes definitely, thank you for your amendment.
My apologies to Adam.

Cordially
Pascal

"Sandy Mann" a écrit dans le message de news:
...
I think papou meant:

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"papou" wrote in message
...
Hello Adam
=COUNTIF(A1:1500,"<#N/A")

HTH

Cordially
Pascal

"Adam" a écrit dans le message de news:
...
Please could someone provide me with a formula that would allow me to
count
the number of cells that do not contain N/A as an entry.

Thanks
Adam

Counting cells that do not contain N/A
 

Hi Sandy,

I often wish I could delete posts when I realise I've goofed <bg

No problems !

Pete

On Oct 29, 11:35 am, "Sandy Mann" wrote:
Sorry Pete,

Not only did I misread your post,I misread the OP's post as well A double
goof!

My apologies to you both.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"Pete_UK" wrote in message

oups.com...



Hi Sandy,

the OP was asking about count - if he used COUNT and the values were
numbers then this would ignore it (and he wouldn't have the problem),
so I assumed they must be text values and he was using COUNTA. I was
also making the distinction between #N/A and N/A, so the OP could put
in the appropriate one if he really meant #N/A.

There's a bit of logic to my posts now and then !! <bg

Pete

On Oct 29, 10:57 am, "Sandy Mann" wrote:
Pete,

If N/A was typed in and thus text, wouldn't SUM() ignore it anyway?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"Pete_UK" wrote in message

groups.com...

If N/A has been typed in (rather than the error #N/A), then try this:

=COUNTIF(A1:A100,"<N/A")

Hope this helps.

Pete

On Oct 29, 10:41 am, Adam wrote:
Please could someone provide me with a formula that would allow me to
count
the number of cells that do not contain N/A as an entry.

Thanks
Adam- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -