Look up 2 columns and count using wild cards

[jmorgan923]

I need to do a look up of one column, compare a 2nd column and where criteria matches I need the formula to count.

I.E. I have an PC inventory and I want to see how many Dell computers are Laptops versus PCs or Servers

The formula I have working right now is: =COUNTIFS($T$1:$T$1960,"Dell",$AB$1:$AB$1960,"Laptop") but what I really need is =COUNTIFS($T$1:$T$1960,"Dell",$AB$1:$AB$1960,"Lap*") [this would catch the words "laptop", "laptops" or "lap tops"]

As soon as I add the * I get a count of 0, however if I enter the word correctly it will add up just that phrase. Any suggestions?

 

[shg]

Your formula works fine for me ...

 

[jmorgan923]

Figured it out, one of the columns that I was searching on was actually an number and you can not do COUNTIFS on a number. And here I though Excel was all about the numbers.

Your formula works fine for me ...