2020-08-01

Equivalent of SUMDIVIDE in Excel

Title

Problem

We want to create the equivalent of the function SUMDIVIDE in Excel, returning the sum of the division of ranges or arrays, the inverse of SUMPRODUCT.

Solution

With SUMPRODUCT we just use the inverse of the multiplication for the array acting as denominator: 1/array as denominator. In our example we return the sum of the division of column 1 by column 2.

=SUMPRODUCT(A2:A6,1/B2:B6)


Another option would be using SUM as an array formula.

{=SUM(A2:A6/B2:B6)}

No hay comentarios:

Publicar un comentario

Nube de datos