How do I sum cells' values over 30+ worksheets?

[Guest]

I am trying to set up a timesheet system for a one year period. How can I
sum up certain biweekly values (ie, time charged, dollar fee) over 30+
worksheets to have a running cumulative total at the end?
=SUM(Sheet1!C34:Sheet30!:C34) does not work.

 

[Bob Phillips]

Try

=SUM(Sheet1:Sheet30!:C34)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)