Quick Question

[Shanee Mac]

I have six worksheets with basically the same information. I want to add the same cells of each worksheet so it can totally on the overall sheet. How do I do that.

 

[Domenic]

Try something like this...

=SUM('Sheet1:Sheet6'!A2)

or


=SUM('Sheet1:Sheet6'!A2:A100)

 

[shg]

You can use a 3D reference:

=sum(sheet1:sheet6!A1)

Change sheet names appropraitely.