I am looking to solve the following problem

Col A Col B Col C Col D
Date received Date Processed Days taken Are days greater than 3
1/2/3 2/2/3 =b2-a2 if(c23,1,0)
1/2/3 5/2/3 4 1
1/2/3 2/2/3 1 0
2/2/3 5/2/3 3 0
5/2/3 9/2/3 4 1
6/2/3 7/2/3 1 0
etc

Cell E1 is a start date, Cell E2 is a stop date. Problem is what
formula would I put in cell E3 to count the number of incident between
the start and the stop date where Col D for the relevant entries are
1?

Any help is appreciated.

s-t-m




--
sonic-the-mouse