Wildcards: * and ?
AdvancedAdvanced
10 questions, about 15 minutes
Count and add up with part of a text, such as everything that starts with GB.
What we'll do
- The asterisk for any number of characters
- The question mark for exactly one character
What you'll use
COUNTIFSUMIF
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
10questionsYou do it yourself