Help with Excel

  Tulips 21:44 19 Jul 2008
Locked

Dear all, how do I get from =SUM('W1'!E$36:F$36) to =SUM('W38'!E$36:F$36) the way I do it at the moment is click on the cell with =SUM('W1'!E$36:F$36)in it and drag it down 38 cells and then manually change the W1 into W2 and so on but I have over 3,000 cells to change so I'm looking for an easier way, hope this is clear enough.

  VoG II 21:54 19 Jul 2008

Try

=SUM(INDIRECT("'W"&ROW()&"'!E$36:F$36"))

  Tulips 22:10 19 Jul 2008

Sorry, am I missing something here, do I just copy the above and paste it in the appropriate cell and drag it down and job done or do I put some other info in there?

  VoG II 22:15 19 Jul 2008

Put the formula in row 1 and fill down. However I'm not sure that I fully understood your requirements but try it anyway.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Acer Predator 21X review

14 best picture books for children

Best podcast apps for iPhone & iPad

Les meilleurs ordinateurs portables 2017