add cells together from different sheets within a workbook
 

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

add cells together from different sheets within a workbook
 

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



s6292 wrote:

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

--

Dave Peterson

add cells together from different sheets within a workbook
 

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

--
Biff
Microsoft Excel MVP


"s6292" wrote in message
...
How do I add cells together from different sheets within a workbook

add cells together from different sheets within a workbook
 

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" wrote:

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



s6292 wrote:

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

--

Dave Peterson

add cells together from different sheets within a workbook
 

Put 1 in A1 of Sheet1

Then...

=sheet1!a1+1
in A1 of Sheet2

=sheet2!a1+1
in A1 of sheet 3

.....


s6292 wrote:

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" wrote:

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



s6292 wrote:

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

--

Dave Peterson


--

Dave Peterson