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, Excel Starter 2010. With COUNTIF, one of the statistical functions, you can count the amount of cells which qualify a criterion; for instance, to count how often a specificContinue reading “COUNTIF function”

# Tag Archives: The SUMIF function adds only the values that meet a single criteria

## 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”