Formula

Hi,

I am working a workbook which have multiple sheets.

I am looking for a formula which will work in 2 sheets.

The detail of the sheets are as mention below.

Sheet-1:- it has 2 column Country name and Number of Devices.

Country Number of devices
UK 100
UK 50
UK 80
Australia 150
Australia 100
India 200

Sheet-2 :- this sheet has again 2 column Country name and number of devices, but in this sheet for one country we need total number of devices (and I am looking for the foumula which will give the below mention result).

Country Number of devices
UK 230
Australia 250
India 200

Please let me know if you need any further information.

Thanks
Sanjay