Sum data value of different sheet of excel [Closed]

Report
-
Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
-
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 reply

Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
462
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

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 ?
Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
462
Now I am lost in what you want to achieve.

Can you post a small sample of your sheets for clarification?

If I found your email i attached a excel file and try to clear what i want to do
Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
462
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!