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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

=SUM(Sheet1:Sheet30!:C34)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Back
Top