add cells together from different sheets within a workbook

[s6292]

How do I add cells together from different sheets within a workbook

 

[Dave Peterson]

=sheet1!a1+sheet3!b99+'sheet 999'!x99
or
=sum(sheet1!a1,sheet3!b99,'sheet 999'!x99)

 

[T. Valko]

=Sheet1!A1+Sheet7!D22+Sheet7!N107

 

[s6292]

what if I have multiple sheets in a workbook and I want a number in a cell to
increase by 1 on each consecutive worksheet?

 

[Dave Peterson]

Put 1 in A1 of Sheet1

Then...

=sheet1!a1+1
in A1 of Sheet2

=sheet2!a1+1
in A1 of sheet 3

.....