CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Philip Hegardt
Philip Hegardt

Reputation: 29

Google Sheets – "Repeat with each"

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

Upvotes: 1

Views: 76

Answers (1)

JPV
JPV

Reputation: 27262

See if this helps

= SUMPRODUCT(B3:B6;C3:C6)

Reference:

Upvotes: 2

Related Questions