SUM 划分两个单元格的结果(SUMPRODUCT 而是划分) [英] SUM the result of dividing two cells (SUMPRODUCT but division instead)

问题描述

我正在寻找与 SUMPRODUCT 等效的方法，但要使用除法.有没有办法将两个数组相除的结果相加?

I'm looking to do the equivalent of SUMPRODUCT but with division. Is there a way to add the results from dividing two arrays?

示例:A 列的资产寿命"以年为单位(10, 20, 10).B 列具有资产 (10,000, 20,000, 20,000) 的值.我想添加 (10,000/10) + (20,000/20) + (20,000/10) = 4,000 的结果，但是当我添加具有生命和价值的行时，公式是动态的.

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.

提前致谢.

推荐答案

由于除法是乘法的逆运算，所以可以这样使用:

Since the division is the inverse of the multiplication, you can use this:

=SUMPRODUCT(1/A1:A3, B1:B3)

=SUMPRODUCT(1/A1:A3, B1:B3)

这篇关于SUM 划分两个单元格的结果(SUMPRODUCT 而是划分)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！