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 responses

Answer 1 / 3
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response