LiveFlow raises $13.5 million Series A led by New York-based Valar Ventures and launches LiveFlow Next to revolutionize accounting!
Read More
Arrow
Back to guides
Google Sheets Formulas

How to Use REDUCE Function in Google Sheets

In this article, you will learn the REDUCE formula and how it works in Google Sheets.

This function is meant to be used with the LAMBDA function. The REDUCE formula process each value in a selected range through the LAMBDA function and returns the total cumulative number in a cell.

So, the REDUCE function is similar to the SCAN function. The difference between the two formulas is that the REDUCE function only shows the total cumulative figure in a cell. In contrast, the SCAN function presents the total and intermediate cumulative numbers in a range.

 

How to Insert the REDUCE formula in Google Sheets

  • Type “=REDUCE” or go to “Insert” “Function”“Array” “REDUCE”.

  • Choose a range that includes input values.

  • Enter a LAMBDA function with placeholders and logic.

  • Press the “Enter” key.

Insert the REDUCE function
How to insert the REDUCE function in Google Sheets

Your next financial spreadsheet could be right here!
100+ spreadsheet templates, from FP&A to tax planning.
Free Spreadsheet Templates

What is the REDUCE function in Google Sheets?

The REDUCE function is beneficial when you want to process some input values through a formula and calculate the total accumulate number.

As the REDUCE function doesn’t show intermediate cumulative results after each calculation for an input value, it may help you to reduce the amount of information on the Google Sheets.

The generic syntax is as follows:

=REDUCE(initial_value, array_or_range, lambda)

Initial_value: This is the value the accumulator adds to the sum of all results computed by the LAMBDA function.

Array_or_range: This is a target range or array to each value in which the REDUCE formula applies the LAMBDA formula.

Lambda: You need to define the LAMBDA function with exactly two name arguments and a formula_expression which contains the names such as “LAMBDA(CurrentCumulative, InputValue, CurrentCumulative+InputValue)”. The first name argument corresponds to a current value in an accumulator, and the second one is a placeholder for each value in the chosen array or range. You can also use your Named Functions here.

For example, assume you are a finance manager. You need to know only about the ending cash balance in Dec 2021, but you don’t care about the ending cash position in the other months. The REDUCE function perfectly works for this purpose. 

REDUCE formula works 
How the REDUCE formula works in Google Sheets

Turn Quickbooks Online data into a Google Sheets dashboard
100+ templates, update automatically, totally secure!
Book a Demo

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how!

Get personal help

We guarantee you personal help on chat or Zoom within maximum 6 hours between 9am and 10pm EST.
Blue Tick
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below

Supercharge your financial reporting today

See LiveFlow in action and discover how to streamline your workflows.