Google Sheets – “Repeat with each”

1
votes

I'm trying to figure out a formula to skip (completely avoid) column D. I need some kind of "repeat with each" setup.

Each row is multiplied and then the columns are added up.

https://docs.google.com/spreadsheets/d/1NFdIdSPQib0XK14zssG6I3mDlc0WUmK6uQMNlrWsfw0/edit?usp=sharing

Picture

1
google-sheetsgoogle-sheets-formula

1 Answers

2
votes

See if this helps

= SUMPRODUCT(B3:B6;C3:C6)

Reference: