Previous Topic Next Topic

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

Answer 1 / 2
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
0
Naveed
Jul 10, 2010 at 12:09 PM
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 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?
0
pejhip
Nov 15, 2010 at 05:45 AM
='Sheet1'!A1 + 'Sheet2'!a1
yaar this formula we have put in another Colom in any Sheet
THANxxxx
0
Answer 2 / 2
najaf
Jul 10, 2010 at 12:41 PM
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