Home » Forums » Open Source Learning Center » Question and Answer

Compare data and addition ( grouping and summing)

Submitted by kumarg19 on 24 September, 2013 - 12:40

I have source file as given below.

Source Table
Name Score
Tony 12
Tony 24
Tony 10
Vinni 14
Vinni 32
Vinni 45
Babu 42
Babu 35
Babu 15
Babu 31
Ajay 16
Ajay 21
Ajay 13

The required result table has to come as
Name Sum
Tony 46
Vinni 91
Babu 123
Ajay 50

AttachmentSize
sample.xls13.5 KB
‹ IF statement not working. A Challenging VBA - Copy data from multiple workbooks into one workbook - Not as easy as it sounds ›
»

Kumarg19, Good

Submitted by Mr.Lobao on 25 September, 2013 - 17:37.

Kumarg19, Good afternoon.

Greetings from Brazil.

This is my first post. I didn't find how to attach a sample here.

Then i'll show my suggestion using formulas to solve your question.

Try to use in  F5 cell this formula: =SUMIF($A$3:$A$15,D5,$B$3:$B$15)
 
Then copy down the formula to the desired results

Please, tell us if is it what you desire.
I hope it helps.
--
Belo Horizonte, MG - Brasil
Marcílio Lobão
 

»