CODEWITHSUNDEEP
excelexcel-formulaexcel-2010spreadsheet
user2051347
user2051347

Reputation: 1669

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!

Upvotes: 0

Views: 5167

Answers (1)

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35853

Try SUMIFS in E2 and drag it down:

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

Upvotes: 1

Related Questions