Sheet-1 + Sheet-2

Solved/Closed
Naveed - Jul 10, 2010 at 11:38 AM
pejhip - Nov 15, 2010 at 05:45 AM
Hello,
i have a problem plz solve it and tell me solution i want to count some cells which are
Sheet-1 and in Sheet-2.
Example: (Sheet-1) A1+A1 (Sheet-2)

tell me the formula.
Related:

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 10, 2010 at 12:00 PM
='Sheet1'!A1 + 'Sheet2'!a1
thanks dear for trying to solve my problem but unfortunately the problem is still here b-coz i have been renamed the sheets as per date like 07-07 & 08-07 & 09-07 that are the name of my sheets and i have been tried to solve through your solution but problem is the same.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 10, 2010 at 12:19 PM
='07-07'!A1 + '08-07'!a1
does not work?
='Sheet1'!A1 + 'Sheet2'!a1
yaar this formula we have put in another Colom in any Sheet
THANxxxx
the formula like this , =Sheet1!A1+Sheet2!A1 the technique is click the row where u want to total of mark. On formula bar type = and than click sheet1, click a1. type + click sheet2,clicka1 and press enter