I also gave a modified answer to meet your new requirement!
Stefi


"Jaydubs" wrote:

Hello Stefi,

Thank you very much for your support.

Indeed you served me with the answer for my original question, ffor which I
am thankfull.

When I checked the outcome, I realised I did not take this into account that
unanswered questions may be caried over into the next month. That is why I
posed my second question, which Roger answered.

So again, thanks for your answer !!

Kind regards,

Jay
--
** Fool on the hill **


"Stefi" wrote:

My solution is an answer exactly to what you asked. If I were you I would
measure the elapsed time from date in to date closed:

Then in sheet2
B2: =SUMPRODUCT(--(MONTH(Sheet1!B$2:B$9)=A2)) 'This many questions were raised in the month
C2: =SUMPRODUCT(--(MONTH(Sheet1!B$2:B$9)=A3),--(Sheet1!C2:C9-Sheet1!B$2:B$9<=30)) 'From B2 this many questions were closed within 30 days

Regards,
Stefi



"Jaydubs" wrote:

Great thanks very much for this super answer.

This is what I was looking for, but now I see that some of the questions are
carried over to the next month........For instance a question is raised on
the last day of the month and answered on the first day of the next month,
how do I take this into consideration?? As these will not appear in the
formula given by you !
--
** Fool on the hill **


"Stefi" wrote:

If on sheet1 you have these columns:
A: question
B: date in (format as date)
C: date closed (format as date)

and on sheet2
A: months (format as number)
B: questions raised
C: question closed in month of raising

Then in sheet2
B2: =SUMPRODUCT(--(MONTH(Sheet1!B$2:B$9)=A2))
C2: =SUMPRODUCT(--(MONTH(Sheet1!B$2:B$9)=A2),--(MONTH(Sheet1!C$2:C$9)=A2))

Regards,
Stefi

"Jaydubs" wrote:

In a sheet in which I keep track of questions coming in, I not the date in
and date closed.

in another sheet I want to check how many questions were raised in a month
and how many closed in the same month.

Each question has its own line.

How can I best tackle this?
--
** Fool on the hill **