Previous Topic Next Topic

Sheet-1 + Sheet-2

Solved/Closed
Naveed - 10 Jul 2010 à 11:38
 pejhip - 15 Nov 2010 à 05:45
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

Réponse 1 / 2
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
10 Jul 2010 à 12:00
='Sheet1'!A1 + 'Sheet2'!a1
Naveed
10 Jul 2010 à 12:09
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
10 Jul 2010 à 12:19
='07-07'!A1 + '08-07'!a1
does not work?
pejhip
15 Nov 2010 à 05:45
='Sheet1'!A1 + 'Sheet2'!a1
yaar this formula we have put in another Colom in any Sheet
THANxxxx
Réponse 2 / 2
najaf
10 Jul 2010 à 12:41
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