Formula for Total Profit

[imrankhan180]

I need to have a formula that should calculate day-wise profit for my garments items like

Original Price	28-Nov-16	29-Nov-16	30-Nov-16
Per Item	Qty Sold	Sold Price	Qty Sold	Sold Price	Qty Sold	Sold Price	Total Profit
500	1	600	1	550	1	620	What should be formula to calculate profit for these three days?

<colgroup><col span="6"><col></colgroup><tbody>
</tbody>

 

[FDibbins]

Hi, welcome to the board

While that is not exactly total profit, it is total sales (you don't bring any costs in), this will run the calc you want...

	A​	B​	C​	D​	E​	F​	G​	H​
1​	Original Price	28-Nov-16		29-Nov-16		30-Nov-16
2​	Per Item	Qty Sold	Sold Price	Qty Sold	Sold Price	Qty Sold	Sold Price	Total Profit
3​	500	1	600	1	550	1	620	1770​

H3=SUMPRODUCT(--($B$2:$F$2="Qty Sold"),B3:F3*($C$2:$G$2="Sold Price"),C3:G3)

 

[imrankhan180]

Thank you very much

This should be something like following as item's original price is there.

Profit = (B*C+D*E+F*G)-(A*B+A*D+A*F)

 

[FDibbins]

=SUMPRODUCT(--($B$2:$F$2="Qty Sold"),B3:F3*($C$2:$G$2="Sold Price"),C3:G3)-SUMPRODUCT(--($B$2:$F$2="Qty Sold"),B3:F3)*$A3

 

[imrankhan180]

Thank you but it turned ZERO

 

[FDibbins]

Here is my suggested formula with your data...

	A​	B​	C​	D​	E​	F​	G​	H​
1​	Original Price	28-Nov-16​		29-Nov-16​		30-Nov-16​
2​	Per Item	Qty Sold	Sold Price	Qty Sold	Sold Price	Qty Sold	Sold Price	Total Profit
3​	500​	1​	600​	1​	550​	1​	620​	270​

H3=SUMPRODUCT(--($B$2:$F$2="Qty Sold"),B3:F3*($C$2:$G$2="Sold Price"),C3:G3)-SUMPRODUCT(--($B$2:$F$2="Qty Sold"),B3:F3)*$A3

 

[imrankhan180]

That turned ZERO

 

[FDibbins]

Then you must be applying in incorrectly, you can see from ,y post that it returned 270. Check your ranges

 

[FDibbins]

x-posted here
Formula for Total Profit