Hello everyone.

I need to sum the arguments in a column, in the following way: A11 = SUM(A1:A10), A12 = SUM(A2:A10), A13 = SUM(A3:A10) and so on.

The problem is that I need to operate with the values in the cells before summing them. For example, for A1, I need to multiply A1 by the value A1 in Sheet 2, then multiply A2 by value A2 in Sheet 2 and by the difference between A2 and A1 in Sheet 3. For the value in A3, I need to multiply it by Sheet2!A3 then Sheet3!A3-Sheet3!A1; and so on until A10. Then I want to sum them.

I can't create different tables to do this step by step since I need to do the same for B11, B12... C11, C12... In other words, I'd probably need to create 360 tables or something like that.

The problem would easily be solved if SUM would let me do something like A12 = SUM(A2*Sheet2!A2*(Sheet3!A2-Sheet3!A1):A10*Sheet2!A10*(Sheet3!A10-Sheet3!A1)) but either it isn't possible or I'm writing something wrong. Is there any way to do this?