count on a date range accross 2 columns 1

[hammers1]

I have 2 columns column A when a ticket was opened and column b, when a ticket was closed.

what I would like to get is a total of tickets the were open between two date ranges for this example 01/02/2005 to 28/02/2005
They would need to have been opened before 28/01/2005 and not closed between the date range ( as I need to see any tickets that are opened during that time but not closed)
From the example below it would pick up 2 tickets

open Closed
01/01/2005 01/01/2005
01/02/2005 01/02/2005
01/03/2005 01/03/2005
01/04/2005 01/04/2005
01/05/2005 01/05/2005
01/06/2005 01/06/2005
01/07/2005 01/07/2005
01/01/2005
01/02/2005
01/03/2005
01/04/2005
01/05/2005
01/06/2005
01/07/2005

 

[SkipVought]

Hi,

I get 1
[tt]
=SUMPRODUCT((A2:A15>=E1)*(A2:A15<=F1)*(B2:B15=""))
[/tt]
where
[tt]
E1: =1/2/2005
F1: =28/2/2005
[/tt]


Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[hammers1]

Skip,
Great thanks for the help and prompt reply, what service and the fix works perfect. I have tried everything today, I think it was a case of not seeing the wood for the trees.