How to total a column in Google Sheets - SUM, SUMIF, SUMIFS formulas

See additional tricks to select ranges in the description. Share your tricks in the comments to the video! In each tutorial, we also present useful Google Sheets shortcuts to help you save time when working with data.

While using Google Sheets formulas, there are several ways to select a range for the function:
🔵 Sum specific cells only:
=SUM(A2,A5) - to total only the values in A2 and A5. Hold Command (for Mac) or Ctrl (for PC) and click on the cells to select.
=SUM(A2:A5) - to total all values in the cells from A2 to A5. Click on the first cell and drag to select other cells.
🔵 Sum a column:
=SUM(A:A) - to total all numbers in the column. Even if the column has a header, it won’t break the formula. Simply click on the column index to select it.
=SUM(A3:A) - to total all numbers from A3 to the end of the column. Type in the values manually in the formula.
🔵Sum a row:
SUM(2:2) - to total numbers in row #2. Simply click on the row index to select it.
SUM (A2:2) - to total numbers from A2 to the end of the row. Type in the values manually in the formula.

Using SUMIF formula, you can total a range that matches only one specific criterion. SUMIFS does the same for multiple criteria. These Google Sheets functions have different structures, so you might need to remember them. Watch our video about how to use Google Sheets FILTER function and learn why SUM(FILTER( is better than SUMIF or SUMIFS.

View additional materials from Railsware and join us on social media:

[svetlanagulotta]

Right to the point, exactly what I was looking for. Thank you.

[thesingularitysociety]

Just what I was looking for - thank you!

[Whatsgoingjohn]

Great video! SUMIFS was the function I was looking for. Thank you!

[skyeferguson]

I'm so thankful you did this video! sumif explanations was exactly what i needed

[josephsanchez]

Thanks so much! I was looking how to add certain cells and you made that happen. Awesome !!

[rene]

Awesome thank you. Just what I was looking for!

[rodrigoa.velascojr.]

Amazing! The sumif function really did help me

[miroslavotasevic]

Thanks a lot!!! The best Google Sheet channel EVER!!!!

[nancymackell]

I had to listen to this a few times before I could understand what you were saying, your accent is a little thick, but good info, thank you.

[vintagetutorial]

Sumif is something I was unaware of... thank you lady to bring this to my knowledge..

[ounternetmarketing]

Thank you, you help A lot, pls keep going we are here to support you

[skylad]

you make it so easy to learn thank you so much

[BitcoinPriceForecast]

Thank you. Really helped! You're a beautiful human being!

[sofaking]

I'm trying to create a sum using a drop down list, so that when I select items from the list the sums are displayed on another column. On a different sheet I have the named items with multiple values example: weight, volume, amount, cost, etc. Any tips?

[missingmovies]

Hello, please keep going like that.you're doing well not just because you're so beautiful but because your explaining is beautiful too!

[WinRadioPh]

How about if for some reason I want to sum the total of a specific date, say in your example, based on the E column, I want to sum it up by the Oct 1 date only and once I change the date, it will automatically change too. is that possible?

[rosewildtrax]

I am looking for an answer, hope you can help. On Excel, if you want to extend the range of cells that a formula relates to, you double click the cell that contains the formula, it shows you the outline of the cells in the range, then you simply click and drag the outline to extend the cells in the range. I.e. you can add another cell that was missed. Sheets doesn't seem to let you click and drag the outline, instead I can only change the range by typing the cell number into the formula to include it. Surely there is a click and drag functionality for this rather than typing? Can you help? Rose

[Vintagetube]

Hello Thank yo for the tutorial. I have an issue when trying to add SUM formula to a column and end range, it is not accepting my formula ( ex: =SUM(B2:E
) it does not highlight the last row in column b, instead it highlights column E. any help?

[jeiowjrioewjrio]

But if I need to calculate the total of a column based on a filter from another column and use the =SUMIF formula, every time I have to specify the criterion and change the value name which can easily become cumbersome. How can I achieve the same thing automatically without having to enter any value names. In Confluence Table Filter And Charts macro, whatever I filter, the sum is automatically displayed and calculated for me without inputting anything. If there's a way to do the same in Google Sheets, that'll be great.

[RobertSkinnerHD]

Just connecting. Very helpful but yes the speech move to fast for my old brain to keep up. Good stuff.