Excel: Countifs with asterisk wildcard


My problem is: Count the number of companies in Pennsylvania with Sales exceeding $2,000 and whose telephone area code is (610). Hint: Use a wildcard asterisk (*). I currently have =COUNTIFS(State,H290,Sales,">2000",Telephone,"610*"). Getting a value of 0. Do i need to keep the () around the 610? Tried multiple ways of stating this and I am still getting 0. Should be 7. Filtered data is below. Appreciate any help. Thank you

ST Sales (000 000) Telephone
PA $ 4,469 (610) 694-2424
PA $ 2,515 (610) 768-3300
PA $ 2,515 (610) 768-3300
PA $ 2,515 (610) 768-3300
PA $ 2,738 (610) 644-1300
PA $ 2,037 (610) 834-6301
PA $ 2,467 (610) 378-0500


This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of March 21, 2017.


For more resources for Microsoft Excel