SUMPRODUCT for more than 2 lists/arrays?

[Zsolt_Bako]

Thank you very much!

Unfortunately I didn’t get a notification when you replied so meanwhile I came up with the exact same solution but your answer could have save me a lot of time and frustration

I’m also posting here your Tips&Hacks post about the general idea behind the solution:

Simulate a For Loop (Reference position inside FormulaMap)

So I was struggling with a problem where I needed to evaluate multiple lists simultaneously. A classic use case for a loop. Coda doesn’t have built-in formulas for classic loops such as for or while. The closest thing being FormulaMap. It takes a list as input and runs every item through an expression. Inside the expression, you use CurrentValue to reference the current item being evaluated. As a result, CurrentValue can be of any type (row, date, etc). But there’s no obvious way to get the ke…

It’s a really smart hack that can come handy in a lot of different situations.
Thanks again!