Excel Formula

[Bittureddy]

I have 52 weeks as columns and 30 products as rows. There are 3 machine machine 1, machine 2, machine 3. Each product takes certain amount of time on each machine to get completed.
Sales
[TABLE="width: 500"]
[TR]
[TD][/TD]
[TD]W1[/TD]
[TD]W2[/TD]
[TD]W3[/TD]
[/TR]
[TR]
[TD]P01[/TD]
[TD]xx[/TD]
[TD]xx[/TD]
[TD]xx[/TD]
[/TR]
[/TABLE]

Processing Time in minutes
[TABLE="width: 500"]
[TR]
[TD]Product[/TD]
[TD]Machine 1[/TD]
[TD]Machine 2[/TD]
[TD]Machine 3[/TD]
[/TR]
[TR]
[TD]P 01[/TD]
[TD]0.6[/TD]
[TD]2.5[/TD]
[TD]1.2[/TD]
[/TR]
[TR]
[TD]P 02[/TD]
[TD]2.2[/TD]
[TD]1[/TD]
[TD]0.9[/TD]
[/TR]
[/TABLE]

I want total processing time on Machine 1, machine 2, machine 3 for W 1 based on the sales. Can any tell me easy way to do this as there are 54 weeks and 30 products.

 

[Jon21990]

Hi
Yes this can be done - I think you're asking for something like:

(for product 1) minutes on each machine / (sales for the week / cost per product) ...

Do you have any cell references so I can write something?

Thanks
jon