Can anyone please help me with this. I would like to find out what is the profit / day. Every time i buy my QTY and Cost is different. Every day my sold QTY and Sold Price is different. It needs to use old inventory with old cost until that is gone then use the new inventory with new price.
For example
Date QTY Cost QTY Sold Profit/Day
5/1/11 10 1.00 6 1.49
5/2/11 0 0 3 1.99
5/3/11 15 1.25 8 1.59
5/4/11 so on
Currently i have this formula but its not working.
=SUMPRODUCT(D$3:D4*E$3:E4)-SUMPRODUCT(B$3:B4*C$3:C4)
Thank you very much!!!
For example
Date QTY Cost QTY Sold Profit/Day
5/1/11 10 1.00 6 1.49
5/2/11 0 0 3 1.99
5/3/11 15 1.25 8 1.59
5/4/11 so on
Currently i have this formula but its not working.
=SUMPRODUCT(D$3:D4*E$3:E4)-SUMPRODUCT(B$3:B4*C$3:C4)
Thank you very much!!!
