Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF cell reference won't work | Excel Worksheet Functions | |||
Countif criteria in another cell | Excel Discussion (Misc queries) | |||
COUNTIF less than cell reference | Excel Discussion (Misc queries) | |||
Could the "Criteria" in COUNTIF function be a cell reference? | Excel Worksheet Functions | |||
Countif with cell reference | Excel Worksheet Functions |