calculate the total

First off I want to say thanks if anyone can help me. Thank!

I have an inventory sheet that has always been in word but I put it in Excel and have one problem.
The last three columns are price per unit, numbered ordered and total cost. All I want to do is set it up so that when I enter a number ordered it will automatically calculate the total cost. I know how to do each row individually but not how to set it up so that all you have to do is enter the amount ordered and automatically get the total cost.

I hope someone understands what I am trying to do and can help because I know it has to be something pretty simple to do.

Thanks so much,
Sindy

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

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?

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

Originally Posted by pjoaquin

Well, I guess one of us had the right answer. It goes to show how two people can interpret questions differently. At least we got it sorted out between us.

I think you're both right, Leith Ross is answering the next logical question....

"The last three columns are price per unit, numbered ordered and total cost. "

Price each #Ordered Total cost

The total cost column would obviously need to be totaled with a Sum function to actually give the spread sheet a useful purpose.

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

Thank you so very much. I am just trying to learn Excel and it can be very confusing! lol.