Multiply each one purchased units with its value and get total : by formula or macro

Dear friends!

I need to process some customer purchasing data;

In store there's nearly 20 or more products and 500 or more customers. each customer purchased one or more products and sometimes they will get many of each item. So i need to a way that can get total value they need to be paid by multiplying each customer purchased units with its value and add them together.

Anyway i'm unable to think about exel formula to do that work (got formula ; but it can't be copied to downward cells)
and
i'm really looking VBA Macro also

Is there any experts

This formula can be copied down because of the absolute references used on the first range:

Please Login or Register  to view this content.

Cheers,

Hello tldk,

Avoid Macros if you can use Formulas.

See WorkBook attached for how the formula is changed and copied down.

@ ConneXionLost,

That is even Better! I should have thought about it!!!..

Thank you both ConneXionLost & Winon for your help. Can you kindly let me know about they way of doing it with macro.. I'd like to learn about it also

Anyway thank you for your help


PS: Ah! @ ConneXionLost ; your solution is easier more than i imagine.. Thannnks..