Try a formula similar to:

=SUBTOTAL(9,'Sheet (1)'!E1:E65536)+SUBTOTAL(9,'Sheet (2)'!E1:E65536)

Good Luck.

"Churley" wrote:

I have 2 worksheets that are grouped. The first sheet contains information on
65,536 rows. Then, the information continues onto the second worksheet.
I want to be able to subtotal column E from both sheets. Is there a formula
to do this? I can fit this subtotal on sheet 2.
Any help would be appreciated.
Thanks