I am trying to isolate data in a spreadsheet used to track requests for
information. To produce cummulative report, I have used the formula
=COUNTIF(Tracker!$G$2:$G$2000,A2)
where Column G has the person to whom the request has been assigned, and
A2:A12 are the names of the person. This provides me with a running total
throughout the year.
However, I now need to produce a monthly report to check how many requests
have been assigned in a particular month. I've tried:
=SUM(COUNTIF(Tracker!$G$2:$G$2000,A6)-(Countif(Tracker!$H$2:$H$2000,MONTH($C$1))+(Count if((Tracker!$H$2:$H$2000)<MONTH($F$1)))
where Colomn H is the date when request was allocated and C1 and F1 are the
perimetres for the report (ie start and finish dates)

It looks like the Countif function doesn't like the "<" or "" in the
criteria. Does anyone have a solution?

Many thanks!
Vibeke