add cells together from different sheets within a workbook

  • Thread starter Thread starter s6292
  • Start date Start date
=sheet1!a1+sheet3!b99+'sheet 999'!x99
or
=sum(sheet1!a1,sheet3!b99,'sheet 999'!x99)
 
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?
 
Put 1 in A1 of Sheet1

Then...

=sheet1!a1+1
in A1 of Sheet2

=sheet2!a1+1
in A1 of sheet 3

.....
 
Back
Top