Total the data in an Excel table

Applies to: Excel for Office 365, Excel for Office 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011. Windows You can easily total data in an Excel table by activating the Total Row option, and then apply one of many functions that are given in a drop-downContinue reading “Total the data in an Excel table”

SUM Function – Overview

This function simply adds values; whether single, cell references/ranges or a combination of all three. For example: =SUM(B2+B3+B4+B5) – Adds each individual cell from B2 to B5. =SUM(B2:B5) – Adds the values in the cell range of B2:B5. Syntax: SUM(number1,[number2],…) Argument name Description number1   Required The first number you want to insert. The number can beContinue reading “SUM Function – Overview”