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 PA PA PA PA PA PA PA .">
Most valuable professional
  • Hot Topics

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 PA PA PA PA PA PA PA

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel