#criteria

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

Nested IF Statements

As things are rarely black and white, what if there is more than one condition? How will the IF statement look? Learn how to use "Nes

IF + AND

“IF + AND” formulas are used to test if a value meets multiple criteria, giving one result, otherwise giving another.

IF + OR

Learn how to use "IF + OR" formulas: if the value is x OR y, THEN a, ELSE b when you have more than one criteria.

SUMIFS

Learn how to ADD cells that meet multiple criteria using the SUMIFS formula.

COUNTIFS

Learn how to COUNT the number of cells that meet multiple criteria using the COUNTIFS formula.

Adding 2 or more COUNTIF formulas

Did you know that you can add the result of multiple COUNTIF formulas? COUNTIF is normally used on it’s own as several entries and then adde

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

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