Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countif ...
I have a column with phone numbers. I want to count how many phone numbers
have the area code "214" and "972". |
#2
|
|||
|
|||
Thanks, the first formula worked.
"Jason Morin" wrote: The formula depends on how your phone numbers are formatted and whether they are text or actual 10 digit numbers. For example, if they are text and you simply need the first 3 numbers in the cell, try: =SUMPRODUCT(--(LEFT(A1:A10,3)={"214","972"})) If the area codes are enclosed in parentheses, you could use: =SUM(COUNTIF(A1:A10,{"*(214)*","*(972)*"})) Posting some examples will help readers give you a formula that works. HTH Jason Atlanta, GA "heater" wrote: I have a column with phone numbers. I want to count how many phone numbers have the area code "214" and "972". |
#3
|
|||
|
|||
The formula depends on how your phone numbers are formatted and whether they
are text or actual 10 digit numbers. For example, if they are text and you simply need the first 3 numbers in the cell, try: =SUMPRODUCT(--(LEFT(A1:A10,3)={"214","972"})) If the area codes are enclosed in parentheses, you could use: =SUM(COUNTIF(A1:A10,{"*(214)*","*(972)*"})) Posting some examples will help readers give you a formula that works. HTH Jason Atlanta, GA "heater" wrote: I have a column with phone numbers. I want to count how many phone numbers have the area code "214" and "972". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |