Explanation of the SUMPRODUCT function The SUMPRODUCT function performs 2 mathematical operations against the numbers that you provide as inputs: Step 1 – Calculates the product of each respective element within your arrays Step 2 – Sums up all of Read more…

# Category: SUMMARIZE Functions

## PRODUCT

Explanation of the PRODUCT function The PRODUCT function will multiply the numbers that you provide as inputs. The image below shows the arguments that the function is asking for: At least 1 numeric input (required) Up to a total of Read more…

## MAX

Explanation of the MAX function The MAX function will return the highest (maximum) number from a range of values that you provide as inputs. The image below shows the arguments that the function is asking for: At least 1 numeric Read more…

## MIN

Explanation of the MIN function The MIN function will return the lowest (minimum) number from a range of values that you provide as inputs. The image below shows the arguments that the function is asking for: At least 1 numeric Read more…

## COUNTA

Explanation of the COUNTA function The function will return the count of values within a range that are numbers (including calendar dates), logical values, text, or error values. Said otherwise, using COUNTA will give you the count of “non-blank” values Read more…

## COUNT

Explanation of the COUNT function The function will return the count of values within a range that are numbers (including calendar dates). The image below shows the arguments that the function is asking for: At least 1 numeric input (required) Read more…

## AVERAGE

Explanation of the AVERAGE function The AVERAGE function will calculate the average of the numbers that you provide as inputs. The image below shows the arguments that the function is asking for: At least 1 numeric input (required) Up to Read more…

## SUM

Explanation of the SUM function The SUM function will add the numbers that you provide as inputs. The image below shows the arguments that the function is asking for: At least 1 numeric input (required) Up to a total of Read more…