I am trying to utilize wildcards with the function presented here: http://www.excelforum.com/excel-form...ml#post2078423

However it doesn't seem to be working, for example:

=CountIfAll(3,"Std3",C14:D37) returns the correct result for my spreadsheet: 2
but
=CountIfAll(3,"Std*",C14:D37) returns 0.

The intention would be for the latter formula to returning at least a value of 2, I'm using Excel 2010, not sure what needs to be changed. . .