I have a list of trouble tickets with ticket#, open and close dates recorded
like this:

A                B                    C                  
1234    05/01/07           06/15/07
4567         04/01/07           07/15/07      
4321         05/29/07          

Timeframe is recorded like this:
D1=06/01/07
D2=06/30/07

I am trying to write the condition below as a SUMPRODUCT.

Condition: (open<D1) && ((close=””) || ((close>D2) && ((close-open) > 30)))

Formula: =SUMPRODUCT((B1:B3<D1) AND ((C1:C3=””) OR ((C1:C3>D2) AND
((C1:C3-B1:B3>30)))

What are the formula notations for AND and OR?

Thank you.