Aug 08 2023 04:22 PM - edited Aug 08 2023 06:51 PM
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:
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.
Aug 08 2023 06:13 PM
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.
Aug 08 2023 06:15 PM
Aug 08 2023 06:15 PM
Aug 08 2023 06:25 PM
Aug 08 2023 06:37 PM
Aug 08 2023 07:58 PM
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
Aug 08 2023 08:03 PM
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.
Aug 09 2023 03:12 AM
Aug 09 2023 03:56 AM
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.
Aug 09 2023 02:32 PM
Aug 09 2023 02:33 PM
Aug 10 2023 02:58 AM
@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.
Aug 10 2023 11:12 AM
Aug 10 2023 12:42 PM
Aug 10 2023 06:02 PM