Ubuntu
openoffice.org package

Auto complete or auto sum

Asked by Bob

I am new to OpenOffice Calc 2.4.1 and am finding the help files confusing.

I am trying to make a simple time sheet.
A= Date B=Task C=Hours D=Cost per hour E= total.

I need to make C*D appear in E for all instances and then the sum of all E somewhere down the E column.

Could someone help me use some sort of auto format tool? Or maybe steer me to a list of template's I could download and use.

Thanks in advance. Bob.

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Bob
Solved:
Last query:
Last reply:
Revision history for this message
h2g2bob (d-j-batley) said : 		#1

In E1, type
=C1*D1
and press enter. It should calculate the value of that one cell.

Select cell E1 - the bottom right of the cell has a blob. Drag that blob down for all the cells you want. This copies the =C1*D1 formula all the way down, changing the 1 to whatever number row it is. Click on E4 and see the formula is =C4*D4

To sum up, click the cell you want the total to go into, click the sum button (a sigma, like an E) and select the cells you want to sum - this is better with pictures so take a look at the "Sum (Calculate The Total Of A Column)" section of http://www.tutorialsforopenoffice.org/tutorial/Spreadsheet_Math.html

Revision history for this message
Bob (bbrazie) said : 		#2

Date Project Hours Per Hour Total
01/20/2009 2 $2.00 Err:529

Thanks for the help but after entering =C1*D1 into E I seem to get the error code of 529.

Any ideas? Thanks in advance. Bob.

Revision history for this message
Bob (bbrazie) said : 		#3

Sorry. (blush)
Your advice worked just fine once I entered the correct cell numbers. <g>.