=SUMPRODUCT(--(Tracker!$G$2:$G$2000,A6),
--(Tracker!$H$2:$H$2000MONTH($C$1)),
--(Tracker!$H$2:$H$2000<MONTH($F$1)))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Vibeke" wrote in message
...
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))+(Countif((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