Hi,

thanks for the input ... tried the complete cell referencing ... but the
date criteria doesn't work ..the count calculated is incorrect

"T. Valko" wrote:

Better to use cells to hold the criteria:

E1 = ABC
F1 = Nicky
G1 = 1/2/2009

=SUMPRODUCT(--(ISNUMBER(SEARCH(E1,A2:A22))),--(B2:B22=F1),--(C2:C22=G1))

--
Biff
Microsoft Excel MVP


"NMT" wrote in message
...
Hi,

I have a table of 3 types of information -
Column A - Query type
Column B - Resolver Name
Coulmn C - Resolution date

I would like to count the number of cases completed by person X (Stated in
column B) on a given date (Stated in Column C) if the query types includes
text "ABC" (Stated in column A)

Have tried Sumproduct ---
=Sumproduct((A2:A22="*ABC*")*(B2:B22="Nicky")*(C2: C22="1/2/2009"))
Can i use the wild card criteria? If I use a normal criteria I can count
the
required data.