Excel基于多个条件求和值 [英] Excel summing values based on multiple conditions

问题描述

我有以下excel工作表，我想根据匹配值和效果代码对值求和.

I have the following excel sheet, and I want to sum values based on an a match value and effect code.

Effect Code   Value   Match Code  Numerator    Denominator
      2        500      111000    
      8        700      111000
      2        900      111000
      8        560      111000
      5        100      211000    
      8        200      211000
      7        300      211000
      8        750      211000

现在分子是效果代码等于8的所有匹配代码的总和，而分母是不是8的任何效果代码.因此，我想得到以下内容:

Now the numerator is the sum of all match codes with an effect code equal to 8 and the denominator is any effect code that is not 8. so I would like to get the following:

Match code    Numerator    Denominator

  111000        1260           1400
  211000         950            400

我想在excel电子表格中有成千上万的行.我尝试使用以下方法进行求和，但是它不能正常工作，而且我似乎无法弄清楚如何解决它:

I have Hundreds of thousands of rows in the excel spreadsheet which I would like to do this on. I have tried using the following to do the summation, however it is not working properly and I cannot seem to figure out how to fix it:

=SUMIF(Match_Code,C2,Value)

上述解决方案类型的另一个问题是，我将有一堆重复的匹配代码，最后，我只想将分子和分母的值相加即可.任何其他可以解决此问题的解决方案将不胜感激.

The other problem I will have with the type of solution above is that I will have a bunch of duplicates of the Match Code, when in the end I just want one with the values of the numerators and denominators summed up. Any other solutions that could get around this problem would be appreciated.

推荐答案

放弃

这篇关于Excel基于多个条件求和值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！