Reputation: 1
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
Reputation: 34411
The function you are looking for is called SUMPRODUCT.
SUMPRODUCT
Upvotes: 1