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. ...
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.
Thank you very much.