Excel Magic Trick 1182

COUNTIFS and Wildcards to Count When There are 4 or More Characters

DESCRIPTION

See how to use COUNTIFS and Wildcards to Count When There are 4 or More Characters with a formula from Bill Szysz at YouTube:
(00:10) Problem setup and review of last video Excel magic Trick
(00:53) COUNTIFS Function to count numbers with 4 or more characters. Raise 10 to a power and link it to a cell with the criteria 4.
(02:00) COUNTIFS Function to count text with 4 or more characters. Use REPT function with wildcards ? and *.
(04:35) Wild Cards for text strings: A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.

Excel wild card characters ? and * for text only? Yes, this information was not in the F1 Help for COUNTIFS, but instead it was in the F1 Help for the MATCH function.