#range

Note: screenshots and examples were taken using Microsoft Excel 2013, however older versions can be used.

Tags

No tags yet.

AVERAGEIFS

AVERAGEIFS allows you to average a set of values that meet multiple criteria. It is useful when you need to make comparisons between differ

AVERAGEIF

Had to average a set of values that met a criteria and didn't know how? AVERAGEIF is a super easy formula to use and understand. I exp

How to remove table functionality

Created a table and then later decided that you no longer want the “table functionality”? Learn how to remove a table's functionality at

SUMIF

SUMIF is used to “sum the values in a range that meet a criteria that you specify” - Microsoft Support Office 2017. It refers to only one c

INDEX-MATCH

INDEX-MATCH is more flexible and powerful than VLOOKUP as it doesn't have the limitations of VLOOKUP. It is a combination of two formula

COUNTIF

COUNTIF, in layman’s terms means COUNT the NUMBER of cells, IF it contains XYZ (text, number, etc). The key word here is criterion, referri

Did you know Excel can generate random numbers?

Let Excel do the work for you - generate random numbers!