View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Churley Churley is offline
external usenet poster
 
Posts: 28
Default SUBTOTAL 2 WORKSHEETS

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