M
Murtaza
Dear Experts,
Consider the following example & provide any best possible formula.
In a Working File:
---------------------------------------
Column A Column B
---------------------------------------
1 Product Name Sales_Units
2 Product "a" 2220
3 Product "b" 5175
4 Product "c" 395
5 Total Value ?? ==> This is cell 'B5'
To get the Total Value, the price for above products are listed in a seprate
sheet "Pricelist", among other 100s of products.
Pricelist:
---------------------------------------
Column A Column B
---------------------------------------
1 Product Name UnitPrice
2 Product "a" 20
3 Product "g" 75
4 Product "c" 95
5 Product "t" 15
6 Product "b" 25
6 etc.... etc....
The required formula or method have to find each product i.e. Product "a",
"b", "c" in "Pricelist" & then multiply its "Sales_Units" by its "UnitPrice"
and then give total value of all products in cell "B5".
I am expecting an answer in cell 'B5' is 211,300
Kindly note that this formula or method should be a global one i.e. I can
use this formula on other sheets or file.
Any Suggestions
Thanks for your understanding!
Murtaza
Consider the following example & provide any best possible formula.
In a Working File:
---------------------------------------
Column A Column B
---------------------------------------
1 Product Name Sales_Units
2 Product "a" 2220
3 Product "b" 5175
4 Product "c" 395
5 Total Value ?? ==> This is cell 'B5'
To get the Total Value, the price for above products are listed in a seprate
sheet "Pricelist", among other 100s of products.
Pricelist:
---------------------------------------
Column A Column B
---------------------------------------
1 Product Name UnitPrice
2 Product "a" 20
3 Product "g" 75
4 Product "c" 95
5 Product "t" 15
6 Product "b" 25
6 etc.... etc....
The required formula or method have to find each product i.e. Product "a",
"b", "c" in "Pricelist" & then multiply its "Sales_Units" by its "UnitPrice"
and then give total value of all products in cell "B5".
I am expecting an answer in cell 'B5' is 211,300
Kindly note that this formula or method should be a global one i.e. I can
use this formula on other sheets or file.
Any Suggestions
Thanks for your understanding!
Murtaza