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.
|