How to sum columns and rows | Google Sheets | Quick Tutorial

In this video, I demonstrate how to sum a column or row of sales data. If you are not familiar with the basics of spreadsheet formulas, check out my Spreadsheet Formula Basics video at:

[jgknick]

Thank you for being so clear. A lot of these youtube videos are so complicated or they tell you 10 different ways to do something and you end up not understanding any of them. This was very helpful.

[SirNathan-vnhu]

I appreciate the straightforward demonstration. Thank you.

[roberthiggins]

I came here for minute 1:45. Thank you for the awesomely concise video. (I was looking how to "copy and paste" in mass so I wouldn't have to keep doing the same formula over and over again.) Yay!

[kalenweb]

Cool - and lots quicker than many other videos (that's why I chose yours to watch)! Thanks much.

[sonistories]

Thanks!! Needed that bit right at 1:45 as well!

[tman]

Thank you so much for this tutorial this is exactly what I was looking for! Thanks again!

[reginaseegert]

Thank you so much for that bit at the end about extending the formula down a column when adding rows, had been over thinking it.

[utndr]

thank you this helpED me figure something out that I couldn't figure out.

[Jenny-scordo]

Thank you for the short and clear explanation! I ran into a slight issue: when I add a $ sign in front of the number, the formula doesn't calculate the total, not sure if there's a setting I have to edit.

[sagnchilders]

I want to sum a row (all cells to the right) but leave it open ended like you did with the column; how? Thank you!

[andre]

Nice Tutorial but what if i have 100 Rows for Example and 100 Colums and i wanna have =SUM(D7:R7) and =SUM(D8:R8) and =SUM(D9:R9) and so on.
Is there a way to replace the Numbers by a Variable like: to make it more reusable?

[sanjuv]

so you showed how you could leave it open ended so that if the sales team adds more rows, the top cell keeps adding to the total by doing sum (a2:a). how could you do the same thing by having a cell on the extreme left that does the same thing for a row, so that if the sales team adds more columns, it could be open ended? your current formula has the sum for rows on the right, so it's assuming a fixed number of columns.

[bondofpvwithgregtee]

I'm trying to sum a row but skiping over a row . like the sum of B2:B5:B6

[gelynmontecillo]

Please help me..im in trouble . Wats the formula for the thing u used on the top to show the sum up the total all..

[mohammedaltayar]

Please help, when I do this in google sheet the number become 0. The row I want to collect is by _

[gelynmontecillo]

Please help me . The formula u use on the total up ..tnx