Basically I have the following data:

£2500 COLLECTED 01/03/2006
£3500 NOT COLLECTED 01/02/2006
£4500 COLLECTED 01/03/2006
£3000 COLLECTED 01/03/2006
£3500 NOT COLLECTED 01/02/2006

What I want to be able to do is in a seperate cell, add up the value of
££££'s for a given date that have been NOT COLLECTED

PLEASE HELP!!!!!!!!!!!!!!!!!!


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=538125