Which google sheets function can I use for this?

I have spreadsheet where I need to do the following:

O5*L5+O6*L6+O7*L7+O8*L8 (...) for a set number of rows (5-48).

What function can I use?

Upvotes: 0

Views: 29

Answers (1)

arrowd
arrowd

Reputation: 34411

The function you are looking for is called SUMPRODUCT.

Upvotes: 1

Related Questions