Previous Topic Next Topic

Sum data value of different sheet of excel

Closed
bal krishna Ghimire - May 12, 2011 at 09:08 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 12, 2011 at 10:27 AM
Hello,

I want to found some formula for summing different sheet.
My problem is like this.
I am one excel worksheet, there are different 12 sheet.
In one sheet there are 60 rows and 25 columns.
This is salary sheet of my company for different months.
There are not same employee and they found salary in different heading.
I want to sum what they found total in one year.

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 12, 2011 at 09:29 AM
Hi bal krishna Ghimire,

Select the cell you want to put the sum formula in. Type "=" then select the sheet and the the cell you want to add then type "+" and select your next cell folowed by a "+" then next cell etc..

Best regards,
Trowa
0
bal krishna Ghimire
May 12, 2011 at 09:33 AM
Thanks for suggestion .
I do this but there are some problem arises, there are different no of employee and not in same order. so there is some difficulty to copy formula from first row so I want to know if there are any other to summing up ?
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 12, 2011 at 09:46 AM
Now I am lost in what you want to achieve.

Can you post a small sample of your sheets for clarification?
0
bal krishna Ghimire
May 12, 2011 at 10:07 AM
If I found your email i attached a excel file and try to clear what i want to do
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 12, 2011 at 10:27 AM
Didn't receive any mail yet.

Note that other people may be watching this query. To keep them in the loop try using a site like www.speedyshare.com to upload your file and post back the download link.
0