Excel 2007 : formula help needed !!

[leo_83]

Dear all,

I have for reference 2 columns from excel chart,

City name Temperature
------------ ---------------

Bombay 34
Delhi 42
Bombay 28.6
paris 16
london 12
bombay 34.2
paris 16
paris 10.2

What i would like to do is place the below calculation in the same sheet where the columns gets over or into another sheet of same worksheet.

Bombay =34+28.6+34.2 = 96.8

, next it will take Delhi and calculate the total for delhi in complete column,

So Delhi = 42

similarly,
now it will know next is Paris and hence Paris =42.2 will be place ..

Can someone please help me out with this..

Thanks with Regards,
leo

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.