Stumps

[stumps]

Hi, can someone assist with the a formula for the 2nd example :

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"][/TD]
[TD="align: center"]K[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Description[/TD]
[TD]Property[/TD]
[TD]vat[/TD]
[TD]Dr[/TD]
[TD]vat[/TD]
[TD]Credit[/TD]
[TD]vat[/TD]
[TD]Bank[/TD]
[TD][/TD]
[TD]Transfer[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Transfer [/TD]
[TD]Eaton[/TD]
[TD][/TD]
[TD]100.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]-100.00[/TD]
[TD][/TD]
[TD]100.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Formula does work in cell k3 :[FONT=&quot]=IF([/FONT][FONT=&quot]$B3[/FONT][FONT=&quot]="Transfer",SUM[/FONT][FONT=&quot]($E3)[/FONT][FONT=&quot]-SUM[/FONT][FONT=&quot]([/FONT][FONT=&quot]$F3[/FONT][FONT=&quot])[/FONT][FONT=&quot]-SUM[/FONT][FONT=&quot]([/FONT][FONT=&quot]$G3[/FONT][FONT=&quot])[/FONT][FONT=&quot]+SUM[/FONT][FONT=&quot]([/FONT][FONT=&quot]$H3[/FONT][FONT=&quot])[/FONT][FONT=&quot],"")


[/FONT][TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"][/TD]
[TD="align: center"]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Description[/TD]
[TD]Property[/TD]
[TD]vat[/TD]
[TD]Dr[/TD]
[TD]vat[/TD]
[TD]Credit[/TD]
[TD]vat[/TD]
[TD]Bank[/TD]
[TD][/TD]
[TD]Transfer-Eaton[/TD]
[TD]Transfer-Festival[/TD]
[TD]Transfer-Junomar[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Transfer [/TD]
[TD="align: center"]Eaton[/TD]
[TD][/TD]
[TD]100.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]-100.00[/TD]
[TD][/TD]
[TD="align: center"]False[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Formula does not work in cell K3 :[FONT=&quot]=IF([/FONT][FONT=&quot]$B3[/FONT][FONT=&quot]="Transfer",)=IF([/FONT][FONT=&quot]$C3[/FONT][FONT=&quot]="Eaton",SUM[/FONT][FONT=&quot]([/FONT][FONT=&quot]$E3[/FONT][FONT=&quot])[/FONT][FONT=&quot]-SUM[/FONT][FONT=&quot]([/FONT][FONT=&quot]$F3[/FONT][FONT=&quot])[/FONT][FONT=&quot]-SUM[/FONT][FONT=&quot]([/FONT][FONT=&quot]$G3[/FONT][FONT=&quot])[/FONT][FONT=&quot]+SUM[/FONT][FONT=&quot]([/FONT][FONT=&quot]$H3[/FONT][FONT=&quot])[/FONT],"")

Have added a Drop List in cell C3 which contains(Eaton Festival Junomar) - would like the total to be inserted in the appropriate cell e.g. Would like a total in L3 If Festival is selected from the drop box in C3.

Thanks in advance

 

[arthurbr]

Perhaps =IF(and($B3="Transfer",$C3="Eaton"),$E3-$F3-$G3+$H3,"")
There is no need for the SUM function if only one cell is referenced

 

[stumps]

Hey many thanks for this, very much appreciated after battling for 2 days with this.

 

[arthurbr]

You're welcome