Calculating cumative values

Hi,

I am working on a massive excel sheet and was wondering if there a simple way to do the following:

I have values such as -

A B C D

But I need to calculate (A*0) and in the next cell (A*1) + (B*0) and then in the next cell (A*2) + (B*1) + (C*0) and then (A*3) + (B+2) + (C*1) + (D*0) each in separate cells.

I can't just do the calculation and need to leave the cell reference for A, B etc. as these values will be changing.

At the moment I am doing it manually but there is a huge sheet and this is prone to human error.

Please let me know if there's an easier way.

Where will these calculations be and where is the source data? How is it presented? Can you provide a sample sheet with some representative (but not sensitive) data?

B3=SUMPRODUCT(($B2:B2)*(COLUMNS($B2:B2)-(COLUMN($B2:B2)-MIN(COLUMN($B2:B2)))-1))

Please Login or Register  to view this content.

Try this and copy towards right