Can anybody explain this fomrula
REDUCE(0,H7:H10,LAMBDA(a,b,VSTACK(TAKE(a,1),a+b)))
h7 1
h8 2
h9 3
h10 4
result
0
4
7
9
10
thanks
Printable View
Can anybody explain this fomrula
REDUCE(0,H7:H10,LAMBDA(a,b,VSTACK(TAKE(a,1),a+b)))
h7 1
h8 2
h9 3
h10 4
result
0
4
7
9
10
thanks
maybe it will help:
The expression you provided is a formula in Excel or Google Sheets that uses the `REDUCE` function along with `LAMBDA`, `VSTACK`, and `TAKE`. Let's break it down:
1. **REDUCE**: This function takes an initial value (in this case, `0`) and a range of values (from `H7:H10`). It applies a function to combine them iteratively.
2. **Initial Value (0)**: The calculation starts with `0`.
3. **Range (H7:H10)**: This is the range of cells that will be processed.
4. **LAMBDA(a, b, ...)**: This defines an anonymous function that takes two parameters:
- `a`: The accumulated value from the previous iteration.
- `b`: The current value from the range being processed.
5. **VSTACK(TAKE(a, 1), a + b)**: This part combines the results:
- `TAKE(a, 1)`: This takes the first item from the accumulated value `a`.
- `a + b`: This adds the current value `b` to the accumulated total `a`.
- `VSTACK(...)`: This stacks the first item of `a` and the sum `a + b` vertically.
### What It Does
Essentially, this formula iterates through the values in the range `H7:H10`, maintaining a running total while also storing the first accumulated value. The result is a vertical array where the first entry is the initial value (from `a`), and the subsequent entries are the cumulative sums of the values in `H7:H10`.
### Example
If `H7:H10` contains values like `1`, `2`, `3`, and `4`, the output would be a vertical array:
- The first value would be `0`.
- The second would be `1` (0 + 1).
- The third would be `3` (1 + 2).
- The fourth would be `6` (3 + 3).
- The fifth would be `10` (6 + 4).
In summary, this formula creates a cumulative sum from the specified range, while also capturing the initial state.
that's all what I can do 4 u
Thanks for your explanation but final result is
0
4
7
9
10
i can't understand
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://eileenslounge.com/viewtopic.php?p=316441#p316441
https://eileenslounge.com/viewtopic.php?p=324736#p324736
https://eileenslounge.com/viewtopic.php?p=324990#p324990
https://eileenslounge.com/viewtopic.php?f=27&t=41937&p=325485#p325485
https://eileenslounge.com/viewtopic.php?p=325609#p325609
https://eileenslounge.com/viewtopic.php?p=325610#p325610
https://www.youtube.com/watch?v=3t8Mk4URi6g&lc=UgzoakhRXOsCaoRm_Nd4AaABAg. 8xzeMdC8IOGADdPM65i9PG
https://www.youtube.com/watch?v=3t8Mk4URi6g&lc=UgzoakhRXOsCaoRm_Nd4AaABAg. 8xzeMdC8IOGADdPQHFk_zm
http://www.eileenslounge.com/viewtopic.php?p=324457#p324457
http://www.eileenslounge.com/viewtopic.php?p=324064#p324064
http://www.eileenslounge.com/viewtopic.php?p=323960#p323960
https://www.youtube.com/watch?v=7VwD9KuyMk4&lc=UgyZCnNfnZRfgwzDlQF4AaABAg
https://www.youtube.com/watch?v=7VwD9KuyMk4&lc=UgyZCnNfnZRfgwzDlQF4AaABAg. ADd4m2zp_xDADd6Nnotj1C
s://www.youtube.com/watch?v=7VwD9KuyMk4&lc=UgySdtXqcaA27wQLd1t4AaABAg
http://www.eileenslounge.com/viewtopic.php?p=323959#p323959
http://www.eileenslounge.com/viewtopic.php?f=30&t=41784
http://www.eileenslounge.com/viewtopic.php?p=323966#p323966
http://www.eileenslounge.com/viewtopic.php?p=323959#p323959
http://www.eileenslounge.com/viewtopic.php?p=323960#p323960
http://www.eileenslounge.com/viewtopic.php?p=323894#p323894
http://www.eileenslounge.com/viewtopic.php?p=323843#p323843
https://www.youtube.com/watch?v=fEHKPhJxgBA&lc=Ugxx8_MjhC9FDaQgcHN4AaABAg
https://www.youtube.com/watch?v=jpjYm4UvyWk&lc=Ugx_Qd4rfAN_ZYcJbo94AaABAg. ACGbG9c76OWACGbjKa7H8k
https://www.youtube.com/watch?v=jpjYm4UvyWk&lc=Ugx_Qd4rfAN_ZYcJbo94AaABAg
https://www.youtube.com/watch?v=GyPHaydeng0&lc=UgzE4a4f_e_y9Rk5OR94AaABAg
https://www.youtube.com/watch?v=I5FkNG94BcQ&lc=UgxXnkEHqulXSR5tXwh4AaABAg
https://www.youtube.com/watch?v=3t8Mk4URi6g&lc=UgzoakhRXOsCaoRm_Nd4AaABAg. 8xzeMdC8IOGABa6BSa173Z
https://www.youtube.com/watch?v=3t8Mk4URi6g&lc=UgzoakhRXOsCaoRm_Nd4AaABAg. 8xzeMdC8IOGABa6-64Xpgl
https://www.youtube.com/watch?v=3t8Mk4URi6g&lc=UgzoakhRXOsCaoRm_Nd4AaABAg. 8xzeMdC8IOGABa5ms39yjd
https://www.youtube.com/watch?v=3t8Mk4URi6g&lc=UgzoakhRXOsCaoRm_Nd4AaABAg. 8xzeMdC8IOGABa5ZXJwRCM
https://www.youtube.com/watch?v=3t8Mk4URi6g&lc=UgzoakhRXOsCaoRm_Nd4AaABAg. 8xzeMdC8IOGABa4Pr15NUt
https://www.youtube.com/watch?v=3t8Mk4URi6g&lc=UgzoakhRXOsCaoRm_Nd4AaABAg. 8xzeMdC8IOGABa4I83JelY
https://www.youtube.com/watch?v=3t8Mk4URi6g&lc=UgzoakhRXOsCaoRm_Nd4AaABAg. 8xzeMdC8IOGADdMo2n-hyF
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
later