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

Author Message
accooper
General User

Joined: 31 Jul 2009
Posts: 7
Location: San Antonio, Texas

 Posted: Fri Jul 31, 2009 7:31 pm    Post subject: add a column and then divide the sum I know this is a beginner question but I am a beginner. How do you add a column and then divide it? I am writing a mileage sheet for my job Andrew_________________Ted Nugent For President
DiGro
Super User

Joined: 02 Jun 2004
Posts: 1415
Location: Hoorn NH, The Netherlands

 Posted: Sat Aug 01, 2009 1:45 am    Post subject: =(A1+B1)/20 where first number is A1 added to second number B1, divided by 20 Hope this is what you were looking for. BTW multiplying is: *_________________DiGro Windows 7 Home Premium and AOO 4.0.1 NL (Dutch)
Villeroy
Super User

Joined: 04 Oct 2004
Posts: 10106
Location: Germany

 Posted: Sat Aug 01, 2009 1:59 am    Post subject: =SUM(A1:A99)/COUNT(A1:A99) [count and sum both ignore text values] ... which is the same as... =AVERAGE(A1:A99) If you get used to always insert new rows into your growing list, all references will adjust to the new size automatically. The above formula becomes: =AVERAGE(A1:A100) after insertion of new cells. Simply typing new values intto the empty grid of cells will NOT expand the references. The trick should work as well when you insert new rows at row 100, directly below the referenced A1:A99. If not, check Tools>Options...Calc>General:"Expand references ...". Likewise you should delete rows from your list._________________Rest in peace, oooforum.org Get help on https://forum.openoffice.org
accooper
General User

Joined: 31 Jul 2009
Posts: 7
Location: San Antonio, Texas

 Posted: Sat Aug 01, 2009 4:13 am    Post subject: Thanks. I will try it. Andrew_________________Ted Nugent For President
accooper
General User

Joined: 31 Jul 2009
Posts: 7
Location: San Antonio, Texas

 Posted: Sat Aug 01, 2009 1:04 pm    Post subject: That's what I needed. Thanks Loads From Texas! Andrew_________________Ted Nugent For President
 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