Hello Roger,

Great, This solves my question. Thank you very much !!

Kind regards,

Jay
--
** Fool on the hill **


"Roger Govier" wrote:

Hi

Formula 2 given to you by Stefi, gives the number raised and closed in
the same month, which, as you rightly point out will omit those raised
lat month, but closed this month.

Either, change formula 2 to take out the test for month raised e.g.

C2: =SUMPRODUCT(--(MONTH(Sheet1!C$2:C$9)=A2))

or leave C2 as it is, and have another category in D2 for those closed but not raised in same period which would be

D2: =SUMPRODUCT(--(MONTH(Sheet1!C$2:C$9)=A2)) - C2


Regards

Roger Govier



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 !