REDUCEformula is used to apply a function to each element of an array, resulting in a single output value. The function specified in
LAMBDAis applied to the elements of the array in turn, and the final result is obtained by accumulating these element-wise results. This formula is often used to sum or multiply the elements of an array.
- How to use
- Examples of using
REDUCEformula not working?
- Similar formulas to
REDUCE formula with the syntax shown below, it has 3 required parameters:
- initial_value (required):
The initial value for the reduction operation. This value is used as the accumulator for the first element in the array.
- array_or_range (required):
The array or range of cells to be reduced. If a range is provided, the cells are read from left to right and top to bottom.
- LAMBDA (required):
A function that takes two arguments: the current accumulator value and the current element of the array. The function should return the new accumulator value.
ExamplesHere are a few example use cases that explain how to use the
REDUCEformula in Google Sheets.
Sum a range of cells
To sum a range of cells, use the
REDUCE formula with an initial value of zero and a
LAMBDA function that adds the current element to the accumulator.
Multiply a range of cells
To multiply a range of cells, use the
REDUCE formula with an initial value of one and a
LAMBDA function that multiplies the current element by the accumulator.
Find the maximum value in a range
To find the maximum value in a range, use the
REDUCE formula with an initial value of
MIN_VALUE and a
LAMBDA function that returns the greater of the current element and the accumulator.
REDUCEnot working? Here are some common mistakes people make when using the
REDUCEGoogle Sheets Formula:
Providing a non-array or non-range input
REDUCE requires an array or range as its second argument. Providing a non-array or non-range input will result in an error.
Not providing a lambda function
REDUCE requires a lambda function as its third argument. Not providing a lambda function will result in an error.
Providing a lambda function with the wrong number of arguments
The lambda function provided to REDUCE must take two arguments. Providing a lambda function with the wrong number of arguments will result in an error.
The following functions are similar to
REDUCE or are often used with it in a formula:
SUMfunction in Google Sheets adds up a range of numbers. This function is most commonly used to sum the values in a range of cells.
PRODUCTformula in Google Sheets multiplies all the numbers given in the arguments and returns the product. It is commonly used to calculate the total product of a range of cells.
MAXfunction returns the maximum value from a range of cells or a set of supplied values. It is commonly used to find the largest value in a dataset.
MINformula is a statistical function that returns the smallest value in a set of numbers. It is commonly used to find the minimum value from a range of cells or a list of values.
The FILTER formula in Google Sheets is used to filter a range of data based on specified conditions. It returns a new range that only includes the rows that meet the specified conditions. This formula is commonly used to extract specific data from a larger dataset.
You can learn more about the
REDUCE Google Sheets function on Google Support.