Fill series with factors from different sheets

[ossa]

Hello!

I have a list of 70 products. Each product has a price. I am distributing these products, to the same people all the time, and would like to make history of how much (in money). Above this amount, there is list of products and quantity for each product. In one sheet I have the prices, and in other one I need the amount. How to make a formula like this in a easy way: (quantity!a1*sheet1!g2+quantity!a2*sheet1!g3........ I hope I made myself clear

Ossa

[Steve0492]

I am a bit confused about what you are asking, the same is likely true for others. I suggest attaching the spreadsheet you are referring to.


***If someone gave you good help, be sure to click the star at the bottom of their post!***

[ossa]

I think I attached the worksheet. The sheet called "Tools" gives information to f.ex sheet "Mindaugas P"

[ossa]

hello!

Does anyone have a clue, regarding this question?