'Spreadsheet automatically multiple rows

I'm trying to make a sheet that I can easily expand on in the future. I want to calculate B3-BX by C-S2. In row 2 of every column I have a different number. I want to multiple that number by the number in each row of B, based on which row I'm currently at.

I can't just copy and paste =C#*B# because it doesn't work. It keeps changing one of the values to the previous row.

This is what I'm trying to do.

This is what I'm trying to do, repeated, faster

spreadsheetmultiplication


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions