Answer the question
In order to leave comments, you need to log in
Google Spreadsheets, how to get sum of products of pairs from ranges?
An example that shows my way of "manual" multiplication of each pair and the final summation:
In fact, it has many pairs and blocks.
Is it possible to somehow multiply pairs of two or more ranges to get the required result?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question