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
<colgroup><col><col><col></colgroup><tbody>
</tbody>
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 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>