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. ...
Thank you for honestly acknowledging that it's homework. We generally don't do homework for people, but a pointer in the direction of how to solve might be OK. So it seems to me that don't want (nor are required) to ONLY use SUMIF. Part of a good SUMIF formula is the criterion that serve as the basis for selecting--in this case--those whose names begin with "Steve" -- which would include "Steve M." and
"Steve R." and all the other Steves, right?
So you need a way to select the part of the name string that is "Steve". for that you'll need the LEFT function.
I'm not asking for a straight up answer, haha, just an example of something like this or as you said, a pointer in the right direction. I like and want to learn excel, I'm kinds simple sometimes and figure I'm messed up and need to fix it is all. Not trying to cheat or anything of the sort.
Thank you insanely much for the help.
Very much appreciated.
Thank you insanely much for the help.
Very much appreciated.