Group sum

[Taki_123]

Hello,

I have a table like below:

<tbody>
</tbody>

Countries	Time spent
SA	300
TR	400
CI	800
SA	500
IN	755
IN	900
BR	1800
FR	500
UK	752
FR	400
SA	800
US EN	733
UK	900
FR	600

<tbody>
</tbody>

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