OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

adding cells from different sheets

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
billbilly
Newbie
Newbie


Joined: 13 Aug 2005
Posts: 3

PostPosted: Tue Feb 06, 2007 3:01 pm    Post subject: adding cells from different sheets Reply with quote

How do I add cells from different sheets? I'm setting up an expense report that has JAN as sheet 1 all the way through DEC as sheet 12. Sheet 13 is Yearly Total.

If I have the value 1 in (JAN:B10) and the same value in the same cell through DEC, how do I set up a formula to total all of the values in B10 from JAN through DEC which is placed in cell B10 on the sheet titled Yearly Total?
Back to top
View user's profile Send private message
Dale
Super User
Super User


Joined: 21 Feb 2005
Posts: 1440
Location: Australia

PostPosted: Tue Feb 06, 2007 4:55 pm    Post subject: Reply with quote

Summing a range across sheets is the same as summing a range within a sheet (OOo 2.x, anyway).

So, if the sheets JAN to DEC are next to each other, with no other intervening sheets, use:
=SUM(JAN.B10:DEC.B10)

If you have one or more sheets between (say) the JUL and AUG sheets, use:
=SUM(JAN.B10:JUL.B10;AUG.B10:DEC.B10)

Similarly
=SUM(Jan.A1:Jun.C3)
will sum the range of cells between (and including) A1 to C3 on sheets Jan to Jun

HTH.
_________________
Dale
To err is human, but to destroy your slippers in the process takes a real son of a bitch: Me!

OOo documentation from the source
http://documentation.openoffice.org
Guides, FAQ, How Tos
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group