I have a similar problem, however, I would like to ask it to look for
conditions based on month of occurrence.

So, I wish to know how many occurrences were initiated by a certain
department (column f) and if the occurrence was rejected (column g), then
which of the rejected occurrences for that specific department happened in
june, july, etc. (column a).

I have come up with some very complicated formulas, however the answers they
return don't jive when put to the test.

Any help would be greatly appreciated as I have spent the better part of a
day working on this . . .


"Toppers" wrote:

=SUMPRODUCT(--(ISBLANK($A$2:$A$10)),--($B$2:$B$10="ACT"),--(C2:C10=X1-183))

where X1 is "Report date"

"MaryZZZ" wrote:

Made a mistake in my previous post. Dawns on me that as time passes,
soon I will not have any rows selected if I compare dates to TODAY().
The data is static and TODAY() is not.

I suppose I need to add a "REPORT Date" to a cell on the spreadsheet,
and count the rows that are GT ("REPORT Date" - 6 months).