Formula Help

[Arafat]

Hello Experts,

I have been working out different formulas to sum up values based on two multiple conditions and the problem being it has to add the value of the existing and the new found value. I have used sumifs but its only showing the TAX amount. please help

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 337"]
<tbody>[TR]
[TD]IRNAPM-J-50087-0415-000-1735057330004SG9999691[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 60"]
<tbody>[TR]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="align: right"]5286.02[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD]here I want add the GST TAX matching the COL A and COLB, i.e 5286.02+370.03[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 337"]
<tbody>[TR]
[TD="width: 337"]IRNAPM-J-50087-0415-000-1735057330004SG9999887[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 60"]
<tbody>[TR]
[TD="width: 60, align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]868.49[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="class: xl65, width: 168"]here I want add the GST TAX matching the COL A and COLB, i.e 868.49+60.79[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 337"]
<tbody>[TR]
[TD="width: 337"]IRNAPM-J-50087-0415-000-1735057330004SG9999691[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 60"]
<tbody>[TR]
[TD="width: 60"]GSTTax[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]370.03[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 337"]
<tbody>[TR]
[TD="width: 337"]IRNAPM-J-50087-0415-000-1735057330004SG9999887[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 60"]
<tbody>[TR]
[TD="width: 60"]GSTTax[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]60.79[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 629"]
<tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[gaz_chops]

Think i was overcomplicating it! MirakelMan is correct just use sumif

=IF(B1=0,SUMIF($A$1:$A$30,A1,$C$1:$C$30),"")

Or if B needs to be checked just for "GSTTax" then

=IF(B1=0,C1+SUMPRODUCT(($A$1:$A$20=A1)*($B$1:$B$20="GSTTax")*($C$1:$C$20)),"")

or

=IF(B1=0,C1+SUMIFS($C$1:$C$30,$A$1:$A$30,A1,$B$1:$B$30,"GSTTax"),"")

 

[Arafat]

Thank you gaz_chops and Mirakel man. Its working perfectly fine and correctly You make our life easier.

 

[gaz_chops]

You're welcome, just beware of using the full column reference as it can slow things down, always try and limit the range to your actual data.

 

[Arafat]

Yes Sir, Thanks for the Tip.

 

[MirakelMan]

You're welcome