Hi,

I have an account excel sheet that keep track of my cheque's/lodgements
etc

I have 4 columns DATE,CHEQUE NO,AMOUNT, CASHED here is a quick example

15/12/2005 224 200.00 YES
20/12/2005 225 100.00 YES
01/01/2006 226 400.00 NO
02/01/2006 227 500.00 NO

these are cheques i made out to people but they may not cash them for
weeks so the above do not affect my current balance until they are
cashed. If a cheque is cashed i update my CASHED COLUMN to YES. So i
tend to view the ones not cashed as pending and i want to be able to
view my current balance and my balance when all pending cheques are
cashed.

in another worksheet it shows my balances:

current balance 2000.00
current pending 900.00
theo balance 1100.00

Now what i want it to be able to do is calculate the fields marked YES
and NO seperately. Can you use an if else statement to do this or is
there another way.

Cheers
Im Baffled


--
whiteswan
------------------------------------------------------------------------
whiteswan's Profile: http://www.excelforum.com/member.php...o&userid=31995
View this thread: http://www.excelforum.com/showthread...hreadid=517265