Group sum

[Taki_123]

Hello,

I have a table like below:

[TABLE="width: 209"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Countries[/TD]
[TD]Time spent[/TD]
[/TR]
[TR]
[TD]SA[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]TR[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD]CI[/TD]
[TD]800[/TD]
[/TR]
[TR]
[TD]SA[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]IN[/TD]
[TD]755[/TD]
[/TR]
[TR]
[TD]IN[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD]BR[/TD]
[TD]1800[/TD]
[/TR]
[TR]
[TD]FR[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]UK[/TD]
[TD]752[/TD]
[/TR]
[TR]
[TD]FR[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD]SA[/TD]
[TD]800[/TD]
[/TR]
[TR]
[TD]US EN[/TD]
[TD]733[/TD]
[/TR]
[TR]
[TD]UK[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD]FR[/TD]
[TD]600[/TD]
[/TR]
</tbody>[/TABLE]

I need to display the sum of the hours grouped by countries. For example :
SA : 1600
TR : 400
FR : 1500
etc
An idea how to proceed, thnx.

 

[Zunit]

Re: Excel - Group sum in excel

Copy the list of countries into a new sheet. Click DATA tab then REMOVE DUPLICATES. this will give you a list of all unique countries.
Then insert formula:
=SUMIF(Sheet1!A:A,Sheet3!A1,Sheet1!B:B)

This is if data is in sheet1 column A and B. And in Sheet3 you have the unique list in column A and this formula would be for column B.

 

[Taki_123]

Re: Excel - Group sum in excel

Thanks, it helps