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…

# Category: CONDITIONAL Functions

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

## SUMIF

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