I need help to sum arrays (or Lists). For example, I have these arrays: [image] I make this formula to sum up to 5 arrays, but every time I get a bigger list of arrays I need to change the formula: [image] I tried to use 2 FormulaMaps, but it always get the wrong CurrentValue, I just can reach …

@Ander I think the desired output is to sum all first elements of each array, all second elements, all third etc. @Welley_Rezende I am pretty much sure that this is a data design problem, and the solution would be to organize the data differently, ideally in a way that each of the arrays’ elements …

@Welley_Rezende Nesting CurrentValues has some limitations that are being addressed by the team. There are some mega threads about it in the forum, if you want to learn more. In the screenshot you present here, it’s unclear to me what exactly is your desired output. That said, see if the formula …

Thanks again @Paul_Danyliuk as always giving the opportunity to learn.:handshake:

Thanks @Paul_Danyliuk ! And Thanks @Ander too! You’re right @Paul_Danyliuk , my desired output was to sum all first elements of each array, all second elements, all third etc. (like in the SumProduct formula). And well, actually, there’s a reason to this be the only way I can have this data. Thanks …

Update: A new feature which will help with this problem: [image] Launched: Reuse logic and create nested loops with the new WithName() formula News from Coda We’re excited to introduce the new WithName() formula which enables two key scenarios - reusing logic within a fo…

Sum n Arrays (or Lists) in Coda

Welley_Rezende February 5, 2021, 8:32pm 6

Update:
A new feature which will help with this problem:

Topic		Replies	Views
SUMPRODUCT for more than 2 lists/arrays?	2	2099	February 28, 2019
Sum of values in nested lists using FormulaMap()	1	1144	January 3, 2021
Need help with summing up lists	11	1765	September 9, 2019
Arrays within a single cell	12	2617	June 18, 2019
How to add multiple values outputed on the same column Making Packs	3	551	December 2, 2022

Sum n Arrays (or Lists) in Coda

Related topics