Stumps

[stumps]

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

B

C

D

E

F

G

H

I

K

2

Description

Property

vat

Dr

vat

Credit

vat

Bank

Transfer

3

Transfer

Eaton

100.00

-100.00

100.00

<tbody>
</tbody>

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]

B

C

D

E

F

G

H

I

K

L

M

2

Description

Property

vat

Dr

vat

Credit

vat

Bank

Transfer-Eaton

Transfer-Festival

Transfer-Junomar

3

Transfer

Eaton

100.00

-100.00

False

<tbody>
</tbody>

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