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

In this video, you will learn how to total a column in Google Sheets using SUM, SUMIF and SUMIFS formulas. Practice your skills here: bit.ly/2NoBlDA
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.

❗Get your personal copy of Google Sheets practice file with SUM, SUMIF, and SUMIFS tasks here: bit.ly/2NoBlDA

View additional materials from Railsware and join us on social media:
🔸Blog: bit.ly/2zDshWj
🔹Facebook: bit.ly/2IoaHs4
🔸LinkedIn: bit.ly/2NLWfjj
🔹Twitter: bit.ly/2QgEVnR
🔸Instagram: bit.ly/2Q9Mf00