Forum Discussion
Professor said HAS to be done with SUMIF function. Combine Salary of those named Steve. NO IDEA here
Excel sheet looks like this: A B 1 Name Salary 2 Steve M. $1,000 3 Mary J. $2,800 4 Joe R. ...
I figured, haha. People probably spend 5-10 years to maser Excel.
He did not mention Wildcard. What is that?
He did not mention Wildcard. What is that?
Andymunchin You can often use two special characters in searches and criteria:
? stands for any single character.
* stands for any number of characters, including none.
Examples:
"J?m" will find "Jam", "Jem", "Jim", "J3m", "J!m" etc.
"H*e" will find "He", "Hue", "Here", "House", etc.
? and * are called wildcards.
- That is quite useful information to know. That will come in handy in the future.
Thank you very much.