Summing cells in Consecutive Worksheets
I have the following entry in Worksheet 2, Cell AT8:
=IF(AS8="win",1+'Week 1'!AT8,'Week 1'!AT8),
....and in Worksheet 3, Cell AT8, I have:
=IF(AS8="win",1 +'Week 2'!AT8,'Week 2'!AT8)
and so on, and so on, and so on!!!!@
Basically, the formula accumulates all the "WINS" in cell AS8 as we work our
way towards the last worksheet.
Instead of copying and pasting from Worksheet 2 to Worksheet 3, the above
formula...then CHANGING the 'Week 2(??)'! reference, etc., etc.,
Is there a way to somehow input:
'Week (n+1)'! or whatever,
thereby avoiding the necessity (obviating) to change the "Week #" reference???
Thanks,
FLKulchar
|