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

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.

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

Try

=SUM(Sheet1:Sheet30!:C34)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Gerry" wrote in message
...
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.