Non-Repetitive formula to SUM the products of numbers

Essentially, I need the equivalent of this:

gTryYmZ.png

The cell rows continue to 280. That is, it starts at 5 and finishes at 280. The picture above shows the first 5 PRODUCTs. As you can see, there is a sequence where each D is multiplied by it's Y. I need to be able to generate a formula that can do this without having to type in each product all the way to 280

Hi Soirah and welcome to the forum,

It looks like

SumProduct($D$5:$D$280,$Y5$Y280)

Is what you want.

https://www.techonthenet.com/excel/f...sumproduct.php