Google Sheets REDUCE Function: LAMBDA Array Formulas in Google Sheets
The Google Sheets REDUCE function collapses an array or multiple arrays into a single, cumulative value.
REDUCE is a helper function for LAMBDA, so we'll use the REDUCE function in association with LAMBDA. The LAMBDA will have an accumulator value and a current value, so it will loop through each item in an array and add the accumulator value to the current value to create a new cumulative value.
In this example, we're looking to find the cumulative Closed Deal amount for all of our sales team using our Salesforce data.
► Come see us: https://www.coefficient.io/?utm_mediu...
Video Timeline
00:00: Introduction to the REDUCE function in Google Sheets
00:21: REDUCE function example
00:55: LAMBDA helper function REDUCE
01:36: Calculate Cumulative Closed Deal Amount
Any questions? Comment below; we have Google Sheets experts on the other side.
#googlesheets #googlesheetstutorial #reducefunction #coefficient
On this page of the site you can watch the video online Google Sheets REDUCE Function: LAMBDA Array Formulas in Google Sheets with a duration of hours minute second in good quality, which was uploaded by the user Coefficient 07 December 2022, share the link with friends and acquaintances, this video has already been watched 1,604 times on youtube and it was liked by 12 viewers. Enjoy your viewing!
