Sheet-1 + Sheet-2 [Solved/Closed]

Report
-
 pejhip -
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
='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.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
='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