Function that follow collums

Copper Contributor

Heya bois i have a simple problem that i have not been able to find an answer to with my lack of keyword knowledge. 

 

I have this function =B9*B13*B14+C9*C13*C14+...

and i want it to continue to follow the letters up x amount of times, without having to do a lot of clicking!

 

how do i make that happen? please help thanks uwu!Screenshot_10.png

1 Reply

Hi Mads,

=SUMPRODUCT(B9:M9*B13:M13*B14:M14)

or what is your max range