Hi, is it possible to use the SUMPRODUCT() function on more than two lists or arrays?
In sheets/excel SUMPRODUCT() works for 30 arrays but here in coda it’s limited to 2. Do you have any idea how could I achieve the results in coda? Is there a workaround?
In my use case I have a table with 3 columns and in each row I have equally sized list of numbers in each cell (see below). The last column would be the SUMPRODUCT() of the 3 lists in each row. In this example below I used SUMPRODUCT() for the first two columns (since the 3rd one’s value is 1 everywhere) but I’d like to include a third column as well:
Thanks a lot!