Please Help!!!!!!!!

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

[Toppers]

=SUMPRODUCT(--(C1:C5=--"2006-02-01"),--(B1:B5="NOT COLLECTED"),--(A1:A5))

HTH

"stapleton2308" wrote:

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