Countif Criteria Reference Cell
 

How can I use Countif to allow me to reference a cell that contains the area
codes of phone numbers to be counted? Below is my feble attempt:

=COUNTIF(Contacts!H3:H229,C4&"*")

where, C4 is the cell that contains the area codes to be searched. The "*"
must be employed, as the area code is only the beginning 3 digits of the 10
digit numbers in the given range.

Countif Criteria Reference Cell
 

What format are the phone numbers in?

(123) 123-1234
123-123-1234
123 - 123 - 1234
1231231234

Do any of the area codes start with leading 0s?

--
Biff
Microsoft Excel MVP


"StephonM" wrote in message
...
How can I use Countif to allow me to reference a cell that contains the
area
codes of phone numbers to be counted? Below is my feble attempt:

=COUNTIF(Contacts!H3:H229,C4&"*")

where, C4 is the cell that contains the area codes to be searched. The "*"
must be employed, as the area code is only the beginning 3 digits of the
10
digit numbers in the given range.

Countif Criteria Reference Cell
 

They are in the following format:

212 555 8888

"T. Valko" wrote:

What format are the phone numbers in?

(123) 123-1234
123-123-1234
123 - 123 - 1234
1231231234

Do any of the area codes start with leading 0s?

--
Biff
Microsoft Excel MVP


"StephonM" wrote in message
...
How can I use Countif to allow me to reference a cell that contains the
area
codes of phone numbers to be counted? Below is my feble attempt:

=COUNTIF(Contacts!H3:H229,C4&"*")

where, C4 is the cell that contains the area codes to be searched. The "*"
must be employed, as the area code is only the beginning 3 digits of the
10
digit numbers in the given range.

Countif Criteria Reference Cell
 

Try it like this:

=SUMPRODUCT(--(LEFT(Contacts!H3:H229,3)=C4&""))

--
Biff
Microsoft Excel MVP


"StephonM" wrote in message
...
They are in the following format:

212 555 8888

"T. Valko" wrote:

What format are the phone numbers in?

(123) 123-1234
123-123-1234
123 - 123 - 1234
1231231234

Do any of the area codes start with leading 0s?

--
Biff
Microsoft Excel MVP


"StephonM" wrote in message
...
How can I use Countif to allow me to reference a cell that contains the
area
codes of phone numbers to be counted? Below is my feble attempt:

=COUNTIF(Contacts!H3:H229,C4&"*")

where, C4 is the cell that contains the area codes to be searched. The
"*"
must be employed, as the area code is only the beginning 3 digits of
the
10
digit numbers in the given range.