Delete Formula Based on Multiple Columns

[Cue]

I'm trying to create a formula to tell me which rows to delete based data in
3 differnt columns. The following is an example with column D as the results.

A B C D
1 6/17/2008 ANN NO DEL
2 6/18/2008 BEE YES DONT DEL
3 6/19/2008 CEE NO DEL
4 6/17/2008 ANN NO DEL
5 6/19/2008 CEE NO DEL
6 6/17/2008 ANN DONT DEL
7 6/18/2008 BEE NO DONT DEL
8 6/18/2008 CEE DONT DEL

This the formula but it not giving the correct results:

=IF(SUMPRODUCT(($A$2:$A$5000<=$F$2)*1,($L$2:$L$5000=$L$2)*1,($J$2:$J$5000<>"")*1)>1,"Del","No Del")

Can someone help me get the correct results in column D please?

 

[MyVeryOwnSelf]

I'm trying to create a formula to tell me which rows to delete based

data in 3 differnt columns. The following is an example with column D
as the results.

A B C D
1 6/17/2008 ANN NO DEL
2 6/18/2008 BEE YES DONT DEL
3 6/19/2008 CEE NO DEL
4 6/17/2008 ANN NO DEL
5 6/19/2008 CEE NO DEL
6 6/17/2008 ANN DONT DEL
7 6/18/2008 BEE NO DONT DEL
8 6/18/2008 CEE DONT DEL

This the formula but it not giving the correct results:

=IF(SUMPRODUCT(($A$2:$A$5000<=$F$2)*1,($L$2:$L$5000=$L$2)*1,($J$2:$J$50
00<>"")*1)>1,"Del","No Del")

I'm kind of guessing what the "correct results" are supposed to be. Maybe
what follows would help getting started.

In D1 put something like this
=IF(AND(A1<=TODAY(),B1="BEE",C1<>""),"Del","No Del")
Then extend down for as many rows as needed.

 

[Cue]

Thank you!
--
Cue

I'm kind of guessing what the "correct results" are supposed to be. Maybe
what follows would help getting started.

In D1 put something like this
=IF(AND(A1<=TODAY(),B1="BEE",C1<>""),"Del","No Del")
Then extend down for as many rows as needed.