Look up 2 columns and count using wild cards

jmorgan923

New Member
Joined
Mar 12, 2012
Messages
7
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?
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Your formula works fine for me ...
 
Upvote 0

Forum statistics

Threads
1,211,802
Messages
6,104,064
Members
447,892
Latest member
madara uchiha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top