Please Help!!!!!!!!

S

stapleton2308

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!!!!!!!!!!!!!!!!!!
 
Top