adding cells from different sheets

billbilly · Newbie Joined: 13 Aug 2005 Posts: 3

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?

Dale · Posted: Tue Feb 06, 2007 4:55 pm Post subject:

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