Countifs criteria

[shaun86]

Having trouble finding the solution to this if there is a simple one. My formula looks like this:

=COUNTIFS(Model,$A10,Package,$B10,Status,"*DS*")

But it is not returning anything. I'm assuming this is because B10 contains varying numbers with 0's in front like "01" or "02" but the Package named group has much longer descriptions like "01 - Standard". It describes what the package contains. I know using asterisks around B10 won't work, I'm not sure how to solve this.

 

[philwojo]

You could add the LEFT function in front of the B10 part if all of your data starts with the two digits. I would do something like this:

left($B10,2)

Put that into your current formula and see if it works.

If there are more than 2 digits change the "2" in the left formula to what you need.