Explanation of the IFERROR function The IFERROR function has 2 arguments as shown below: value value_if_error You can use other Excel functions within both of the arguments as well. Note: I typically use the IFERROR to clean up the results of Read more…

# Author: Marc Detesan

## OR

Explanation of the OR function The OR function accepts up to 255 logical conditions as shown below, with each argument separated by a comma. logical1 logical2… all the way up to [logical255] How the function works At least 1 of Read more…

## AND

Explanation of the AND function The AND function accepts up to 255 logical conditions as shown below, with each argument separated by a comma. logical1 logical2… all the way up to [logical255] How the function works Each of your arguments Read more…

## IF

Explanation of the IF statement The IF statement has 3 arguments as shown below: logical_test [value_if_true] [value_if_false] Understanding how to use the IF statement is important because it’s one of the most basic functions yet incredibly useful and powerful. Note: Read more…

## Cell Referencing – What does $ in Excel formula do?

Explaining Cell Referencing and what $ in Excel does The $ in Excel is used to control absolute cell referencing in your formulas. There are 2 types of references: Relative references Absolute references If you have ever written a formula Read more…

## COUNTIFS

Explanation of the COUNTIFS function The COUNTIFS function allows you to evaluate for multiple criteria with the following argument structure: criteria_range1, criteria1 criteria_range2, criteria2 Note: You can input up to a max of 127 [criteria_range, criteria] In the image below Read more…

## COUNTIF

Explanation of the COUNTIF function The COUNTIF function is asking for 2 arguments as shown below: range criteria Example data used to explain how the COUNTIF function works 3 different colors each color has 3 different sizes 2 locations (color Read more…

## AVERAGEIFS

Explanation of the AVERAGEIFS function The AVERAGEIFS function allows you to evaluate for multiple criteria with the following argument structure: average_range criteria_range1, criteria1 criteria_range2, criteria2 Note: You can input up to a max of 127 [criteria_range, criteria] In the image Read more…

## AVERAGEIF

Explanation of the AVERAGEIF function The AVERAGEIF function is asking for 3 arguments as shown below: range criteria [average_range] Example data used to explain how the AVERAGEIF function works 3 different colors each color has 3 different sizes 2 locations Read more…

## SUMIFS

Explanation of the SUMIFS function The SUMIFS function allows you to evaluate for multiple criteria with the following argument structure: sum_range criteria_range1, criteria1 criteria_range2, criteria2 Note: You can input up to a max of 127 [criteria_range, criteria] In the image Read more…