SUM the result of dividing two cells (SUMPRODUCT but division instead)
excel, excel-formula, sum
Solution
Since the division is the inverse of the multiplication, you can use this:
=SUMPRODUCT(1/A1:A3, B1:B3)
Problem
I'm looking to do the equivalent of `SUMPRODUCT` but with division. Is there a way to add the results from dividing two arrays? Example: Column A has the "life" of an asset in years `(10, 20, 10)`. Column B has the Value of the asset `(10,000, 20,000, 20,000)`. I want to add the result of `(10,000/10) + (20,000/20) + (20,000/10) = 4,000`, but for the formula to be dynamic as I add rows with life and value. Thanks in advance.