Home

Function that follow collums

Mads Eriksen
Occasional Visitor

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

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies