Search code examples
excelexcel-formulaexcel-2010spreadsheet

Sum Up rows with the same name and value

I have a table which looks like that:

enter image description here

I want to sum up all the values which have the same name string and the same date, so that I get such a table:

enter image description here

I have to say that I do not know how such a thing could be implemented. I tried something like an if...else structure, but what I am missing is the checking part of the other rows. Any suggestion how to implement such a problem?

I appreciate your answer!

Solution

  • Try SUMIFS in E2 and drag it down:

    =SUMIFS($C$2:$C$10,$A$2:$A$10,A2,$B$2:$B$10,B2)