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.

can you elaborate on the stucture of the array.
I do not see two complete colomuns.

"Bob" wrote:

Hello,
Ive got a array formula problem that I havent 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 Im 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 cant get anything to work for whats 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.

On Feb 12, 6:57*pm,
wrote:
can you elaborate on the stucture of the array.
I do not see two complete colomuns.


Three columns in first matrix shown, which has some blank (not closed)
issues.
Second matrix has opened, closed, and backlogged. There's actually
even a issue code column, but that's the easy part of this issue.

Count of all issues opened in a month, which ones were closed, and
backlogged is the one's that were left open after that month.

Thanks,
Bob