Try this:

=SUMPRODUCT(--(Sheet2!E2:E2175=A5),--(Sheet2!$O2:$O2175=F4))

--
Biff
Microsoft Excel MVP


"Francis" wrote in message
...
I need to calc the total number of help desk tickets completed by a tech on
a
given date from a source worksheet that contains tickets for all techs on
multiple dates.

Using the below formulas I'm able to get the total tickets on a specifc
date, and also get the totals by tech for the entire month. What I need
is
to calc the tickets by tech, by date. My select criteria in the fomulas
is a
cell from another worksheet

=COUNTIF(Sheet2!$O2:$O2175,F4) = ticket counts by date
=COUNTIF(Sheet2!E2:E2175,A5) = tickets counts by tech for the entire month