Forum Discussion
Professor said HAS to be done with SUMIF function. Combine Salary of those named Steve. NO IDEA here
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.
- I got the sites y'all provided bookmarked and looking into them already.
I was trying to look on Microsoft to find anything to help but I was probably looking in the wrong area/place to find the answer I was needing. Like I said, I'm usually great at finding answers to things I don't know or need more on, but couldn't with this. Or perhaps I did and just needed it put more simply to understand it. Some of the terminology and way it works confuses me, but I keep trying. I don't like to quit.
I'm old school myself, even though I'm 37. I prefer books over digital materials. I got the paper book for this class a week or two into the class and figured things out myself relatively quickly just from my own logic as to where and how and why, etc.
I see there are multiple ways to do something with excel like this. I thought of one way, but didn't know how to go about it/write it in correctly. So perhaps I found an answer just didn't know the right way to write it. You guys helped me figure that out with the sites you provided which clarified it for me greatly. Sometimes I just need an example or a visual to fully understand something, like in this case.
I'll take your advice and do that.
OJT is usually how most people learn things.
Thanks again, the help was greatly appreciated.