IFERROR

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…

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…