SUM a ROW

0:00 So I'm gonna show you how to sum a row in a few different ways. We're gonna sum consecutive cells , and we're going to sum non-consecutive cells bunch of different times. So we have here our sales reps and their sales every month of the year. We can enter data here like this. And we want to get just the entire year's sales. Let's go yearly sales over here. We're going to equal sum, and right away it's gonna offer us an option. In this particular case, because I have data here, I don't want that. I wanna just explain it to you. But basically, we're gonna do equals sum, and then we're going to put in B2. We can type that in, or if we do equals SUM, parentheses…

0:51 As long as you see a little underscore in gray, we can actually select the cell. Now, this sum is just gonna sum that particular cell. If we wanna get a range , we need to put a colon. And then where 's the end of the range ? Where 's the last column? In this particular case, where 's the last column that we wanna add up to? And then, in this case, it's M2, so I can type in M2. I can also, when I have this selected, not just click a cell, but click and drag, and I can select B2:M2. It's filling it in automatically as I click and drag. I just need to add a parentheses at the end. And sometimes, actually, if I just hit Enter- I don't have to add a parentheses at the end. This might be a little confusing for people who are new to spreadsheets, but Google's trying to help us here.

1:37 Google Sheets is trying to help us, and it will complete this. However, in Apps Script it's not gonna do a parentheses. Sometimes you have like a comma and then you hit enter and it doesn't, or it adds this comma and we're like, "Oh, I didn't wanna add the comma." Don't rely on Google Sheets to know exactly what you're doing all the time. It's doing its best to guess. It's doing its best to figure out what you're trying to do, and it's gonna lead you that way. But you might wanna do something different. So that's how to add up this entire row . And now I wanna add up each row. I could, because I have data here, I can actually just double click on this dot on the bottom right, and that will automatically put in the sum for every single row.

2:25 See, on row nine it's B9 to M9. And I say to, but I really mean I'm writing a colon. That means it's going from B9 all the way, including every cell in between, to B to M9. From B9 to M9. Okay. If I wanna do Q1, Q1 sales, which are just gonna be January, February, and March, I'm gonna do the same. Equals sum. And instead of going from B2 to M2, I'm going to click and drag just the first three cells . These… And it'll say B2 colon D2, and it'll ask me to autofill . Again, if I wanted to do this I'm gonna say yes, do this, thank you, Google. But if I don't, I'm gonna hit the X. Hey.

3:10 Let's say I wanna get January, April, July, and October. These are the first months of each quarter. I wanna see how are we doing the first month of each quarter. I'm gonna equal sum again. Just gonna give us some more room here to work. Equal sum. And in this particular case I'm looking for cells that are not adjacent to each other, not consecutive cells . So I could select B2, and then if I then select April in the second row, you see it switched. It's not actually summing them all up. What I have to do is click the B2, then add a comma, and then select this April, then add a comma. Then I want July, add a comma.

3:56 And October. Actually, I, I messed up here. I don't want- July. Oh, wait, I do want July. Yes, that is the first month of the quarter. I'm gonna end parentheses and hit enter, and it's gonna suggest autofill . Again, check these that this is what you want. Yes, every single row I want the addition of summing up all of the first quarters. If you have any other specific questions of how you want to sum up this, put in the comment below. I'm happy to answer in a future video You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here.

4:41 Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.