[libreoffice-users] How to movea sum of all worksheet in one summary to a new spreadsheet

I have to keep a "log" on my results with a summary weekly final results.

My worksheet has seven tabs (Monday - Sunday), I need a final 'weekly'
summary on two results in my 'daily' log.
Here what I have:
(cell c4 is my daily total for failures and c8 is my shipping totals for all
days).

For example on Mondays worksheet in cell d5 I have "total failures =" and d6
I have "units shipped =" 
in e5 I have the following:
=sum(c4+Tuesday.c4+Wednesday.c4+Thursday.c4+Friday.c4+Saturday.c4+Sunday.c4)
in e6 I have the following:
=sum(c8+Tuesday.c8+Wednesday.c8+Thursday.c8+Friday.c8+Saturday.c8+Sunday.c8)

My problem is:
On Monday I create a new weekly log that carries over the last work day (for
example, copy Friday log to the new week on Monday). There is other data
that is running all the time, so the last work day is carried to the next
week.

When I try to copy the values in e5 and e6 to the  new week I get a "ref"
error, if I rewrite it manually it works.

My question is how can I copy e5 and e6 correctly to the new weekly
worksheet?

I hope this is clear and thanks ahead for any help or suggestions.






--
View this message in context: 
http://nabble.documentfoundation.org/How-to-movea-sum-of-all-worksheet-in-one-summary-to-a-new-spreadsheet-tp4018041.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted