Count the phone number excluding 0 & #N/A

**Sanjibghosh** · 11-14-2016, 04:35 AM

How to count the phone number excluding 0 & #N/A in a Phone no column by formula. Please help

PHONE
0
0
6641630
66563500
0
33080808
+919820298744
26782916
22172450
0
0
25564048
#N/A
#N/A
#N/A
66539047
#N/A
30801154
0
#N/A

**samba_ravi** · 11-14-2016, 04:49 AM

=COUNT(A1:A200)-COUNTIF(A1:A200,0)
try like this

**Sanjibghosh** · 11-14-2016, 05:03 AM

Hi nflsales

i am using this formula but it is not getting proper result. Actually i want to exclude 0 and #N/A from the attached list.

**samba_ravi** · 11-14-2016, 05:45 AM

Then try
=counta(a2:a200)-countif(a2:a200,0)-countif(a2:a200,"#n/a")

**Sanjibghosh** · 11-14-2016, 06:08 AM

Thanks nflsales

**AliGW** · 11-14-2016, 06:21 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Count the phone number excluding 0 & #N/A

LinkBack

Thread Tools

Rate This Thread

Display

Count the phone number excluding 0 & #N/A

Re: Count the phone number excluding 0 & #N/A

Re: Count the phone number excluding 0 & #N/A

Re: Count the phone number excluding 0 & #N/A

Re: Count the phone number excluding 0 & #N/A

Re: Count the phone number excluding 0 & #N/A

Thread Information

Users Browsing this Thread

Similar Threads

Need an easy way to count number of cells in a range excluding hidden data

[SOLVED] Phone number format - reference post (Formatting Textbox to type phone numbers only)

Count Number Of Rows Excluding Headers Of Different Files And Place it In A Summary Sheet

[SOLVED] Count number of cells excluding duplicates

Count how many phone number is repeated

Is it possible to make Excel dial a phone number from my smart phone?

!HELP! how to count the number of records excluding blank cells

Bookmarks

Bookmarks

Posting Permissions