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. $3,000
5 Steve P. $1,000
6 Steve H. $1,500
7 Tina M. $1,000
8 Joseph R. $2,200
9 Larry M. $1,400
10 Larry P. $1,200
11 Joe T. $3,100
12 Lisa M. $2,800
13 Lisa P. $2,150
14 Lina J. $2,100
15 Mary R. $1,175
16 Mary S. $2,000
17 Joe P. $1,175
18
19 Steve
20 Mary
21 Larry
22 Joe
23 Lisa
INSTRUCTIONS ARE TO:
Using the SUMIF or AVERAGEIF function accomplish the following:
- In cell B19 calculate the combined salaries of all employees with the first name Steve (2 points)
- In cell B20 calculate the combined salaries of all employees with the first name Mary (2 points)
- In cell B21 calculate the combined salaries of all employees with the first name Larry (2 points)
- In cell B22 calculate the combined salaries of all employees with the first name Joe (2 points)
- In cell B23 calculate the AVERAGE salaries of all employees with the first name Lisa (2 points)
You must have a SUMIF formula is cells B19, B20, B21, B22 to derive answer to get credit for the element.
I HAVE BEEN AT THIS FOR OVER 12 HOURS STRAIGHT NOW AND STILL HAVE N.O. IDEA HOW TO MAKE THIS WORK.
I have tried so many combinations with SUMIF/SUMIFS and nothing but error messages. It is due at midnight tonight.
I just need an example or SOME idea of how the SUMIF formula will/can/does work for this?
Because the regular way of doing SUMIF (like I did with the last homework where I had NO issues whatsoever doing this) is resulting in nothing but a 0 or error message.
Apparently most/all of our class is having trouble with this.
Any help is greatly appreciated.
Thank you very much.
15 Replies
I HAVE BEEN AT THIS FOR OVER 12 HOURS STRAIGHT NOW AND STILL HAVE N.O. IDEA HOW TO MAKE THIS WORK.
In those 12 hours you have never looked at the Microsoft documentation? It is all there.
https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b
I am usually pretty fast and good at finding out solutions to things like this, but this one stumped me.
I couldn't find much of anything to help me, or if I did, I'm too new to Excel and didn't notice.
Sometimes I'm a simple person.
I try to be exceedingly thorough and read over things multiple time and spend a lot of time making sure of things.
I don't know all of the resources/help that is offered. I think I was around, maybe even on that page, but this stuff is all kinda similar to me.
Some things like this confuse me and look like something else.
Thanks for sharing that, you have helped this dummy (me) out with more info.
Thank you much.
The resource that Patrick2788 pointed you to, Exceljet.net, is a good one to bookmark.
Microsoft's own documentation, which Detlef_Lewin pointed to, is also good, though generally written more for the person who knows what he/she is looking for.
During the days that I was learning to use spreadsheets (back in the 1980s, long before you were born), I would make it a practice to read through the printed manuals that came with the software discs (I said it was a long time ago). And I'd always find a better way to do something that I'd already done in a more convoluted way. With Excel, as even this thread has shown, there are almost always two or three different ways to resolve a problem, two or three different ways to manipulate text strings in this case.
My real recommendation to you would be to get a book like Excel for Dummies, which actually is a very good starting point, and read it through, trying things out. The other helpful approach is to set yourself a task that you want to do--e.g., set up a personal budget tracking system--and then figure out how to do it. It'll take trial and error, but that's one of the best ways to learn--doing something you care about.
- This will help you arrive at the solution without giving the answer.
https://exceljet.net/formulas/sum-if-cells-contain-specific-text- Thank you as well.
There is so much to this and I enjoy finding out, learning, and hunting down answers doing my own thing.
Even though it frustrates in greatly, haha.
Is there any way to learn ALL of Excel, such as becoming a master at it in a year or two on your own besides the only route I can think of: Buying books, MANY hours of practice and exercises, tutors, etc.
There any useful/helpful tools, sites, or anything/anyone that anyone can recommend to help someone like me learn all about this to master it?
Probably take me a few years or decades, but I'm persistent.
Thanks to you both, greatly.
Very much appreciated.- Andy, as long as you have a way to APPLY and USE excel constantly, you will pick it up and build your foundation and grow. You cant take a class and never use the skills or practice and expect to be proficient, so being able to apply what you are learning on an ongoing basis is KEY, just my opinion.
With that being said, sure Microsoft has available documentation and there are forums like this but I have found the most valuable resource to be You Tube University. Theres a gajillion videos on use case specific needs that take you through and show you step by step how to accomplish your need.
Additionally you can pick up a lot of quick tips, tricks and shortcuts from Tik Tok! Somehow the algorithm showed me a couple Power BI and Excel posts and I followed them and soon after I started seeing all sorts of 1-2 minute videos on daily time/life saving hacks/tips/tricks!
Just keep at it and you will get there 🙂
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.
