[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
TeddieS
General User

Joined: 14 Jun 2012
Posts: 5

 Posted: Thu Jun 14, 2012 3:48 pm    Post subject: [Solved]Calc Formula between sheets help please I use Calc to enter the fuel receipts for the company I work for. I have Cash, Charge and Checks. Once there we have to total each month. What my issue is I need a sheet with all the final total for each months Fuel. (Cash, Charge, etc...) How do I link between all 12 sheets and enter just the totals for each month. I really don't feel like manually typing all this in. Do I highlight the cell, move to the sheet Click the cell I want the total from or what? I am so tired of dealing with these idiots at work I need to get it done now. Each completed month ends on a different row so I can do a total at the top of each sheet that is in the same position, just a different monthly sheet. Any help would be appreciated. Teddie PS it needs to be pretty simple because I am not an expert with this program!!!!Last edited by TeddieS on Thu Jun 14, 2012 7:57 pm; edited 1 time in total
scsisys
OOo Enthusiast

Joined: 17 Dec 2009
Posts: 164

Posted: Thu Jun 14, 2012 4:25 pm    Post subject:

 Quote: so I can do a total at the top of each sheet that is in the same position

If you go that route, lets say the cell is A6 on sheet1 to sheet 12 for the "cash" sales.
On your " totals" sheet ( sheet 13 ??), enter =sum(sheet1.A6:sheet12.A6) for a total
of all monthly "cash" sales. Same procedure for "Charge" and "Checks", just different
cell references.

scissys
_________________
OO 3.2.1
Win XP /SP3
TeddieS
General User

Joined: 14 Jun 2012
Posts: 5

 Posted: Thu Jun 14, 2012 4:36 pm    Post subject: Okay my sheets are named by month and year. I only need the complete total of all receipts for each month. Not the totals of all cash, etc... I just need to link 1 cell from each sheet. This is the actual name of the actual sheet. 'Jan 2011 '.A2 It isn't linking or anything and it is driving me batty, if I can get this then I can set this up for good and not keep having to do this month after month year after year. ARG
scsisys
OOo Enthusiast

Joined: 17 Dec 2009
Posts: 164

Posted: Thu Jun 14, 2012 4:54 pm    Post subject:

 Quote: This is the actual name of the actual sheet. 'Jan 2011 '.A2

it appears that there is a space between 2011 and the '.A2 . Don't know if
that is what is on your actual sheet or just a typo in your post but that will
cause an error. Otherwise, it works for me.

=SUM('Jan 2011'.A2:'Mar 2011'.A2)

scsisys
_________________
OO 3.2.1
Win XP /SP3
TeddieS
General User

Joined: 14 Jun 2012
Posts: 5

 Posted: Thu Jun 14, 2012 7:25 pm    Post subject: Hi I am not trying to add them all up just want 1 cell from each sheet reported. January \$2800.73 February \$4678.38 These totals are already calculated on each monthly sheet I just want to me able to link them straight to the Totals page. I don't know if I didn't make that clear, all the amounts on each sheet are totaling fine. I just cant seem to get the cell A2 for each month to post on the main sheet. I have tried everything I can think of and every way to write it out, hyperlinking too. Just can't it to report there. Keep getting an error.
ozzie

Joined: 29 Jul 2010
Posts: 316
Location: victoria

 Posted: Thu Jun 14, 2012 7:50 pm    Post subject: Easiest way, on your summary sheet where you want the January total type = and then without doing anything else move to the January sheet and click once only on the A2 cell and then click enter. repeat as required_________________If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
TeddieS
General User

Joined: 14 Jun 2012
Posts: 5

 Posted: Thu Jun 14, 2012 7:56 pm    Post subject: That was it thanks!!!! I knew there was some easy way to do this. I used to be able to do it in Excel but haven't worked with it in so long!!! Many Many Thanks again!!
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum