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
In questa pagina del sito puoi guardare il video online Google Sheets REDUCE Function: LAMBDA Array Formulas in Google Sheets della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Coefficient 07 dicembre 2022, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,604 volte e gli è piaciuto 12 spettatori. Buona visione!
