How do I find the sum (total) amount?

Hello, forgive me if I dont make much sense as English is not my native language.

Example:

I have is a number of different products i am selling for different prices. And people buy these on every other day (different dates).

What I am trying to find is - sum amount.

Attached is a example I have which I manually added/typed (without any formula.

- Kevin bought 1 Strawberry (price 80000) on March 26 = Subtotal is 80.000

- Brian bought 1 Apple (20000), 1 Orange (40000) on March 26 = Subtotal is 60.000

- George bought 1 Apple, 1 Orange, 1 Banana on March 26 = Subtotal is 110.000

How do I formula this? Pls help. Greatly appreciated!

Originally Posted by AliGW

Still using Excel 2010?

Thank you. This works nicely. 1 more thing - what if I may need to add quantity for each produc? Example if I Kevin bought 2 strawberries? Thank you.

Originally Posted by TMS

Try this, copied down:

Formula:

Please Login or Register  to view this content.

Thank you. This works nicely. 1 more thing - what if I may need to add quantity for each produc? Example if I Kevin bought 2 strawberries? Thank you.

Originally Posted by AliGW

Still using Excel 2010?

Haha no. Its office 2021 pro plus

Originally Posted by TMS

Where would you put the quantities?

I envision that quantities need to be next to each product. Honestly, not sure where to put it. Do u have any simple/clear idea on it? I am open to it. Unfortunately, date purchased needs to be in there as it is now. Because sometimes people will 3 apples and 10 bananas on same day .

Is it impossible to formula this scenario with Excel? Thank you so much for helping me with this headache.

Originally Posted by AliGW

Well, update your forum profile, then, please!

Explain where the quantities would be - upload an amended workbook.

Uploaded updated (kind of) workbook. Not sure where to put the quantities to make it simpler & easier to understand. And of course, easy to formula. I am open to suggestions.

Originally Posted by Glenn Kennedy

Please update your sample file, as previously requested.

Uploaded updated (kind of) workbook. Not sure where to put the quantities to make it simpler & easier to understand. And of course, easy to formula. I am open to suggestions.

Originally Posted by Glenn Kennedy

No need to make the same reply twice!! Once is sufficient.

K3, copied down:

=SUMPRODUCT(B3:H3,$B$2:$H$2)

Thank you all for help.