REDUCE

Reduces an array to an accumulated result by application of a LAMBDA function to each value. Learn more

Video field
Array

The REDUCE function in Google Sheets is a powerful tool for performing iterative calculations on arrays or ranges of values. It takes three arguments:

  1. The initial value: This is the starting value for the iteration. It can be any valid value or reference.

  2. The array or range: This is the set of values to be iterated over. It can be a range of cells, an array of values, or any other valid reference to a set of values.

  3. The lambda function: This is a function that defines the operation to be performed on each element of the array or range. It takes two arguments: the accumulated value from the previous iteration and the current element of the array or range.

The REDUCE function applies the lambda function to each element of the array or range, with the initial value passed as the first argument. The results of each iteration are accumulated and passed as the first argument to the next iteration, until all elements of the array or range have been processed. The final result is the accumulation of all the intermediate results.

The lambda function can be any valid function that takes two arguments, such as SUM, PRODUCT, AVERAGE, MAX, MIN, or any custom function that you define.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!