This example will multiply the cost per unit by the number ordered.

Quote Originally Posted by pjoaquin
Let's say, for example, that your 'Price per unit' is in column F, your 'Number Ordered' in column G, and your 'Total Cost' in column H.

If your data starts in row 2, then in H2 put this formula:

=F2*G2

This will multiple your Price Per Unit by your Number Ordered to give you a Total Cost. Then, you can fill that formula down as many rows as you need to (either select H2 through your last row in columns F&G and use Edit > Fill > Down, or simply click the lower right corner of cell H2 and pull downward to the bottom row of your data and then let go of the mouse).
This example will add the cost per unit to number ordered?
Quote Originally Posted by Leith Ross
Hello Sindy,

You're right it is something simple. In the Total cell starting typing the formula

=SUM(

Left Click the first cell in the column to be totaled and hold the mouse button as you move to the last cell in the column you want totaled. For this example will say the range if F6:F25. The total formula will look like this...

=SUM(F6:F25

Type a closing paren ")" to complete the formula, and click the check mark on the Formula Bar. Repeat the process for each Total. The final result will be ...

=SUM(F5:F26)

Now, when you type a value into your column it will automatically be sum the contents of the column.

Sincerely,
Leith Ross