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: How to avoid broken formulas

## Combine text from two or more cells into one cell

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 Mobile. Data from numerous cells can be joined into a single cell using the Ampersand symbol (&) or the CONCAT function. Combine data with the Ampersand symbolContinue reading “Combine text from two or more cells into one cell”

## IF Function

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. The IF function is one of Excel’s most recognised functions, enabling you to make logical comparisons between a value and your expected outcome. Therefore, anContinue reading “IF Function”

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