Summary page

[Huber57]

I have 50 (or so) worksheets and I have created a 51st as a summary page. I
would like to total cell C20 on all 50 pages on the 51st. The problem is
sheet names are too long and I can't a formula big enough to accomplish this.
Is there a way to use VBA to get around the formula length constraint and
total all C20 cells on my summary sheet?

thanks in advance!

 

[Ron de Bruin]

hi Huber57

See
http://www.rondebruin.nl/linksum.htm

 

[Mike H]

Put a sheet called Start & end as the first and last sheets. Hide them if you
want and then this sums a1 in every sheet

=SUM(Start:End!A1)

Mike

 

[Huber57]

Ron and Mike,

thanks much!

Put a sheet called Start & end as the first and last sheets. Hide them if you
want and then this sums a1 in every sheet

=SUM(Start:End!A1)

Mike