 ending points, except the start, the first one at 55, I started it at 49. So I should have said these ones, 55, then at 57 to 59 to 61 to 63. Now I'm going to take the ending points. So the ending points end at 57. So there's the 57. And then again, I'm just going to add 2057 plus 2059 plus 2000 to 61. In Excel, I would do that by saying equals the cell above it plus 2000. And then I can simply copy that down. That's not the only way you could do it. You can also type in a couple of these numbers. It'll make a trend. And then you should be able to copy it down. And Excel will be able to see the, see the relationship, the pattern. So in any case, there's the two now, now in Excel, if I'm going to, if I'm going to use Excel to do this, I would like to then get a bucket that's labeled like this 55,000 comma 57,000 or 55,000 to 57,000 something that looks like this. You can type that into Excel. One way to do that is simply, of course, to type into the cell 49,000 to 57,000. Note, however, you have to be careful when typing numbers or when you're trying to type something in that has like an equal or a plus or something like that where you don't want it to actually do a function, a calculation or change it to a number format, but simply put in what you typed. So sometimes you need to put an apostrophe before you type something in to tell Excel, Hey, look, I just want you to put what I typed in there. I don't want you to try to make a formula from it. However, even if you type it in there, it's still kind of tedious to do. So we've put these two in here pretty quickly. These two columns, we were able to copy the columns down, even if we have large columns, what we would like to do is make a formula so I can copy the formula down. So when I have formulas that have like text in it, they can look pretty complicated. But once you do them a few times, they're not that bad. So if you wanted to do this with a formula instead of typing it, it would look something like this equals, we're going to pick what's in cell in this cell, which is represented by C 17 here. And then when I want to put a text field, I have to put quotations around it. So this is going to say, I want you to take that what's in this cell. I don't want you Excel to do a formula. I don't want you to add to it or subtract or anything like that divide. But instead, I want you to just combine it. That's why we have and I want you to and take that cell and and then in quotations type the text of just a dash. That's not a minus sign. I don't want you to subtract the two cells Excel. I want you to just put a dash between them and then and the other the next piece, which is D 17 that represents this cell. So it looks a little complicated. You could just type it in there. You can see in theory what we're doing. But in Excel, it would be great if you can get faster at doing these things. Then of course, you can do these conceptual concepts quickly in Excel, which helps you to really understand things faster because you're able to practice with them faster. So then we can then do a formula to try to say what's in that bucket. Now clearly, I could just go into my data and I could say, Well, the 55,000 in that bucket and then I can go to the second bucket and say it's 57 to 59 and I can go in here to 57 and count the ones up till I get to 59 and so on and so forth. But that's tedious. So clearly, we want to be able to do that in Excel. So this is another complicated looking formula. But if you're able to get the formulas down, then it's quite useful. So you can see what we're doing in concept. And then if you if you were to do this in Excel, you can do a count ifs formula. So what we're telling Excel, I want you to select this entire range. And I want you to count the numbers, meaning I don't want you to add them or subtract. I just count them if and there's an if with an s because we want you to have multiple conditions, there's going to be multiple conditions. What are those conditions going to be? Well, I want you to count everything that's greater than 14 49,000 up to and including 57,000. So so those are the two conditions. Now note that when I start to add this formula down, you might say, Well, wait a second, I want stuff from 49,000 to 57,000, 57,000 to 59,000, 59,000 to 61,000. What if, for example, the number is exactly 59,000? Which bucket is it going to be in? Is it going to be in this bucket? Or is it going to be in the bucket down below? And the answer we typically gonna gonna want here is I want to include it in the upper bucket. So I'm going to say this bucket is 57,000 to 59,000. This bucket is actually everything above 59,000 up to and including 61,000. And by the way, that's why I put 49,000 here, instead of 55,000 as the lower range, because I want it to be below the lower the lower range. So I can say that I want you to pick up everything that's above this number. And if I put 55,000, then it would be right on the line equal to. So I want it to be 49,000 on that first one. And that's why we have that difference. And I'll have that difference in this first bucket than I have up here. Okay, so let's do that. Then I'm going to say, I'm going to say count ifs, and then we selected the range. Now this is my argument. So we said count ifs, I selected the range with this argument, there's the range, and then comma to the next argument. So now, because we want to have greater than, we have to use the, the quotations again. So we've got to use the quote greater than quote, and then we're going to combine it with and therefore we need the and the C17. And so that's going to be saying, I want everything that is greater than what's in C17, the C17 representing this 49,000. So this is the table being selected, comma, you want to count everything that's greater than what's in C17, which is this 49,000. Now if I just hit enter there, it would take everything, it would basically count the whole thing, I think it's 51 numbers, because it's all greater than that lower limit. But we have the second condition, comma condition number two, which is going to select the entire table again. So we're just redoing the thing entire table, comma, the condition here, quotation marks needs to be less than or equal to. So notice that that first condition was, I just needed to be greater than this number. I'm not saying or equal to, I just greater than this one I needed to