Sum Up rows with the same name and value

问题:

I have a table which looks like that:

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:

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!

回答1:

Try SUMIFS in E2 and drag it down:

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