Checkbook balances only what is posted

[jamesrice174]

I'm making a checkbook (shown below) in excel and I have a poste
column. If the posted column has a "Y" in it then that row has bee
posted and I either add the deposit or subtract the withdrawl. I ca
get the SUM statement to work to take the previous balance and add th
deposit AND subtract the withdrawl with the following line,
=SUM($F2,C3,-D3).
I can get the line =SUM(IF(E4:E13="Y",C4,D4)) to do calculations if th
posted coulmn has a "Y" in it but I can't get it do do all of i
together
C D E F
1 DEPOSIT WITHDRAWAL POSTED BALANCE
2 200.00 Y 200.00
3 10.00 Y 190.00
4 25.00 190.00
5 50.00 Y 140.00

Any ideas how to do this

 

[PeterAtherton]

C D E F

1 DEPOSIT WITHDRAWAL POSTED BALANCE
2 200.00 Y 200.00
3 10.00 Y 190.00
4 25.00 190.00
5 50.00 Y 140.00

Any ideas how to do this?

JAmes

One way, with deposit in B, withdrawal in C and Posted in D

In E2 type =SUMIF(D2,"Y",B2)
In E3 type =SUMIF(D3,"Y",B3)-SUMIF(D3,"Y",C3)+E2

Regards
Peter

(e-mail address removed)

 

[PeterAtherton]

C D E F

1 DEPOSIT WITHDRAWAL POSTED BALANCE
2 200.00 Y 200.00
3 10.00 Y 190.00
4 25.00 190.00
5 50.00 Y 140.00

Any ideas how to do this?

JAmes

One way, with deposit in B, withdrawal in C and Posted in D

In E2 type =SUMIF(D2,"Y",B2)
In E3 type =SUMIF(D3,"Y",B3)-SUMIF(D3,"Y",C3)+E2

Regards
Peter

(e-mail address removed)

 

[Sandy Mann]

No need for the SUMIF's

In F2 type =IF(COUNT(C22),(E2="Y")*(C2-D2),"")
In F3 type =IF(COUNT(C33),F2+(E3="Y")*(C3-D3),"")

and copy F3 down as far as necessary. This will also give blank cells in
Column F until an entry is made in C or D

HTH

Sandy

 

[Peter Atherton]

-----Original Message-----
No need for the SUMIF's

In F2 type =IF(COUNT(C22),(E2="Y")*(C2-D2),"")
In F3 type =IF(COUNT(C33),F2+(E3="Y")*(C3-D3),"")

and copy F3 down as far as necessary. This will also give blank cells in
Column F until an entry is made in C or D

HTH

Sandy

Nice oneSandy

Peter Atherton

 

[jamesrice174]

Thanks so much for the help. It works great