Formula to work out subtotal

[KalC]

Hi there guys and girls, I'm sure this is a very easy resolution to this!

Basically, I am trying to create a simple order form sheet for a business for my customers in which they can fill out and send back to me via email for any orders they may have. I have attached the actual worksheet for you all to look at.

I would like my customers to edit the "Quantity" column in turn when they do that, the "Product Subtotal" column will auto update to the total amount of orders they have made in relation to the prices in the "Customer Price" column. What I would like to know and what I need help with, is a formula for doing this! For example if a customer wanted 1x Aloe Vera Gel, 1x Aloe Berry Nectar and 1x Aloe Lotion from the product list, the "Product Subtotal" should update automatically to give me a subtotal for this customers particular order.

As I said, I'm sure there is a way I'm just no good at Excel!!

Look forward to your help and thanks for your time.

Much appreciated,

KalC

[jeffreybrown]

Easiest method could be to add a total column in column E and then sum up column D.

E2 copied down

=C2*D2

[joebell]

=SUM(D2:D44)

Try entering this formula in cell E2. It will add the totals from each of the product quantities entered. I believe this is what you are trying to do.

Joe

[e.isayev]

=SUMPRODUCT(C2:C44,D2:D44)

After entering the quantity the amount will update itself. Unless the quantity cell is empty or zero it will not be included.

[joebell]

eisayew, I misunderstood what KalC was looking to do and I gave the wrong solution. But I must admit that I learned something from you that I didn't know. Thanks!

[e.isayev]

Thank you joebell, Actually I oftenly do the same,
Sometimes because of my poor english and sometimes because of other reasons. I think most of us here to learn something rather than teach, especially myself.
Wish you luck. Thank you

[KalC]

Problem solved! I entered the formula =SUMPRODUCT(C2:C44,D2:D44) and it's exactly what I wanted it to do so thank you eisayew.

Thank you all though for the quick responses, really appreciate the help! I'm sure I'll be back when I need more help

Have a good evening guys

KalC

[jeffreybrown]

Thank you for the feedback...

==================================================================

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[KalC]

Thank you for the feedback...

==================================================================

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Done

Just browsing the forum, a lot of help here for beginners like me! Think I'll start with some of the links in the sticky.. great forum, keep up the good work!