Sumproduct division in google spreadsheets

Question

When working in excel, to find the sum of the quotients of corresponding numbers in two sets, you use a function as follows:

=SUMPRODUCT(A1:A5 / B1:B5)

In google spreadsheets though, although the sumproduct function exists, it cannot do division like this.

In case you are not familiar with excel, this is basically what I want to achieve:

Column A: 5, 7, 3, 9, 4 Column B: 3, 2, 9, 8, 4

Result: (5 / 3) + (7 / 2) + (3 / 9) + (9 / 8) + (4 / 4)

Please note I am using google spreadsheets and not excel!

Rianna

Answer 1

Try using the following formula:

=ARRAYFORMULA(SUMPRODUCT(A1:A5 / B1:B5))

Foreknowledge

Ahh, ArrayFormula, constantly having issues with this. Thankyou! – Rianna

Answer 2

While the answer above works, it's using sumproduct for no reason. Really, what it does it this:

=SUM(ARRAYFORMULA(A1:A5 / B1:B5))

As far as I know, there is no "sumdivision" in Gsheets.

Eastward