Excel汇总行的相应行值

Here's a sample Excel sheet:

这是Excel表格示例:

x	y
---------
a	5
b	4
a	6
a	8
b	4
b	6
a	3
c	1
c	2

I'd like to get the summation of corresponding values from column x.

我想从列x得到相应值的总和。

For example a = 5+6+8+3 so the summation of corresponding values of a = 22

例如a = 5 + 6 + 8 + 3,因此a = 22的对应值的总和

3 个解决方案

#1

Have you tried SUMIF?

你试过SUMIF吗?

SUMIF( range, criteria, [sum_range] )

SUMIF(范围,标准,[sum_range])

You can use, for instance:

你可以使用,例如:

=SUMIF(A1:A9, "a", B1:B9)

To sum all values in column B which corresponding value from column A is "a".

对B列中的所有值求和,其中A列的对应值为“a”。

#2

This will do the trick:

这样就可以了:

=SUMIF(X1:X10,"=a",Y1:Y10)

Adjust your ranges accordingly.

相应地调整范围。

#3

I copied your sample to Excel and verified:

我将您的示例复制到Excel并验证:

=SUMIF(A2:A10,"a",B2:B10)

#1