Previous Topic Next Topic

I Can't drag the formula

Closed
atlga01 - Feb 17, 2011 at 12:12 PM
 rayh - Feb 17, 2011 at 07:01 PM
Hello,

I have 30 sheets each sheet has a total in A3 and on my 31 sheet is the Grand total . How can i tell excell to copy my total from A3 and when i drag the formula it will do a automatic taking the information from sheet 2 sheet 3 and so on

thank you

3 replies

Answer 1 / 3
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
Feb 17, 2011 at 02:16 PM
i dont get the 2nd part
for the first you can have some thing like this


=sheet1!a3 + sheet2!a3
0
Answer 2 / 3
rayh
Feb 17, 2011 at 07:01 PM
=SUM(Sheet1:Sheet31!A3)
0
Answer 3 / 3
rayh
Feb 17, 2011 at 07:01 PM
In Sheet 31
=SUM(Sheet1:Sheet30!A3)
0