Hello,
I’ve got a array formula problem that I haven’t been able to get
through and hoping I could get some help.

I have a worksheet with two tabs

On one tab I update with data each month
Issue Opened Closed
xx Jul-08
xx Jul-08 Aug-08
xx Aug-08 Jan-08
xx Aug-08 Sep-08
xx Sep-08 Dec-08
xx Sep-08
xx Oct-08 10/22/2008
xx Oct-08
xx Nov-08 Dec-08
xx Dec-08 Jan-09
xx Jan-09
xx Jan-09
xx Feb-09 Feb-09

On the other tab I’m tracking how many opened a month, closed a month,
and ones left open for that month.

All All All
Month Open Closed Backlogged
Oct-08
Nov-08
Dec-08
Jan-09
Feb-09

I can get what is open each month, and what is closed each month using
sumproduct function, but I can’t get anything to work for what’s left
for each month. I need to see what is open that was opened for the
last few months, exclude those that were closed in previous or same
month, and exclude those that were closed in future months. Nothing
that I can come up with works. Can anyone help?

Thanks in advance.