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.

2 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 10, 2010 at 12:00 PM
='Sheet1'!A1 + 'Sheet2'!a1
0
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.
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 10, 2010 at 12:19 PM
='07-07'!A1 + '08-07'!a1
does not work?
0
='Sheet1'!A1 + 'Sheet2'!a1
yaar this formula we have put in another Colom in any Sheet
THANxxxx
0
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
0