close
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)
quot;Gerryquot; gt; wrote in message
...
gt; I am trying to set up a timesheet system for a one year period. How can I
gt; sum up certain biweekly values (ie, time charged, dollar fee) over 30
gt; worksheets to have a running cumulative total at the end?
gt; =SUM(Sheet1!C34:Sheet30!:C34) does not work.
全站熱搜
留言列表
