Pulling sum from other sheet

Discuss the spreadsheet application
Post Reply
Martin Pinkston
Posts: 1
Joined: Tue Nov 08, 2016 7:01 pm

Pulling sum from other sheet

Post by Martin Pinkston »

Hello Group and thank you in advance for answering my question.
I have a time sheet invoice template open and on the sheet that lets you put in the individual daily hours, it gives you an hourly total at the end.
I would like to pull that hourly total from one sheet into the invoice billing sheet.
How can I do that?
Thanks again for helping.
Marty
Open Office 4.1.3 on Windows 7
User avatar
soby
Volunteer
Posts: 150
Joined: Sat Oct 29, 2016 10:49 am

Re: pulling sum from other sheet

Post by soby »

hey

i don't know if the sheets are separated and in the same map
but take a look at sample

Soby
Attachments
working hours.ods
(8.78 KiB) Downloaded 115 times
Libre Office 6.1 dev homebuild Open Office 4.1.5 on Slackware64 current
TheBug43
Posts: 6
Joined: Mon Nov 07, 2016 2:45 am

Re: Pulling sum from other sheet

Post by TheBug43 »

Go to Invoice sheet and select cell for the hourly total. Press = sign and return to original sheet and select hourly total. press enter
Windows 7 and OpenOffice Ver. 4.1.3
Post Reply