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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 12, 2011 at 10:27 AM
Related:
- Sum data value of different sheet of excel
- Mark sheet in excel - Guide
- How to take screenshot of excel sheet on laptop - Guide
- How to open excel sheet in notepad++ - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Google sheet right to left - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
May 12, 2011 at 09:29 AM
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
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
May 12, 2011 at 09:33 AM
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 ?
May 12, 2011 at 09:46 AM
Can you post a small sample of your sheets for clarification?
May 12, 2011 at 10:07 AM
May 12, 2011 at 10:27 AM
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.