Sum data value of different sheet of excel
Closed
bal krishna Ghimire
-
12 May 2011 à 09:08
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 12 May 2011 à 10:27
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 12 May 2011 à 10:27
Related:
- Sum data value of different sheet of excel
- How to copy data from one excel sheet to another - Guide
- Excel move data from one sheet to another - Guide
- How to copy data to multiple worksheets in Excel - Guide
- Excel hyperlink to another sheet - Guide
- Export data from excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
12 May 2011 à 09:29
12 May 2011 à 09:29
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
12 May 2011 à 09:33
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 ?
12 May 2011 à 09:46
Can you post a small sample of your sheets for clarification?
12 May 2011 à 10:07
12 May 2011 à 10:27
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.