Formula to get total Price

[Anantha Krishna]

Hello All,

I need your help to get formula for the below scenario.

Having multiple config on 1st column and prices at 2nd column, so i need total price for each config on 3rd column.

Below example for your reference.

Config	Price	Total Price
35399707​	0​	65​
35399707​	5​
35399707​	0​
35399707​	60​
35453959​	113​	265​
35453959​	76​
35453959​	76​

Thank you in advance,

Regards,
Anantha

 

[bosco_yip]

Try,

In C2, formula copied down :

=IF(COUNTIF(A1:A2,A2)=1,SUM(B2:B$1000)-SUM(C3:C$1000),"")

 

[Anantha Krishna]

Thank you so much Bosco_Yip