| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting cells that are 0 in a range of non-contiguous cells | Excel Worksheet Functions | |||
| Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) | |||
| Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Linear Mode
