W

#### wma

filter, I get a sum.

=SUM(IF(DATA4<DATEVALUE("4/1/2008"),IF(DATA6="",IF(DATA6>DATEVALUE("3/31/2008"),$E$11:$E$15942,0),0),0))

I have two date colums (DATA4 & DATA6) that I want conditional statments and

to sum a quantity colum (E). Date colum DATA6 will have both - cells with

dates and blank cells that need to be counted.

Notif.date Notif.qty Completn date

06/29/2006 1

07/10/2006 1 10/09/2008

01/17/2007 1 10/10/2008

02/02/2007 1 08/01/2008

01/09/2008 1 06/06/2008

01/09/2008 1 07/24/2008

01/21/2008 1

01/22/2008 1 10/13/2008

Is there a way to make this work with a formula?

Thanks,