总结不同行中客户端的值

In Excel I'm trying to sum up the values in a column to work out the total number of within a company with multiple row

在Excel中,我试图总结一列中的值,以计算出具有多行的公司内的总数

Company     Number   Total
   A         15       SUM A
   A         30
   A         5
   B         215      SUM B
   B         30
   C         36       SUM C
   D         24       SUM D
   D         8000

I need to work out how to get a total value for A, B, C etc fora couple hundred firms in the output column "total"

我需要弄清楚如何在输出栏“总数”中获得A,B,C等总价值的几百家公司

2 个解决方案

#1

You could use formulas like:

您可以使用以下公式:

=SUMPRODUCT(--(A2:A500="A")*(B2:B500))

one each for each Company.....(adjust the limits to match your data)

每个公司各一个.....(调整限制以匹配您的数据)

#2

You could use the SUMIF function to summate the values in the number column if they match a certain company. For example:

如果它们与某个公司匹配,您可以使用SUMIF函数汇总数字列中的值。例如:

=SUMIF(A1:A30,"=A",B1:B30)

Would sum the number(column B) value for all "A" companies. You could also link evaluation criteria to something like this:

将所有“A”公司的数量(B列)值相加。您还可以将评估标准链接到以下内容:

=SUMIF(A1:A30,"=" & C1,B1:B30)

If the c column held the names of each company.

如果c列保存了每个公司的名称。

#1