add a column and then divide the sum

accooper

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 · 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 OOo 3.3 NL (Dutch)

Villeroy · 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 http://forum.openoffice.org

accooper · Posted: Sat Aug 01, 2009 4:13 am Post subject:

Thanks. I will try it.

Andrew
_________________
Ted Nugent For President

accooper · Posted: Sat Aug 01, 2009 1:04 pm Post subject:

That's what I needed. Thanks Loads From Texas!

Andrew
_________________
Ted Nugent For President