Just in March of 2006?

=sumproduct(--(text(a1:a10,"yyyymm")="200603"),
--(b1:b10=8877),--(c1:c10="James"))

Adjust the range to match, but you can't use the whole column.

FPJ wrote:

How would you write the formula when there are 3 columns involve?

A B C
2/3/2006 8877 Gerry
2/12/2006 8877 James
2/22/2006 5566 Cindy
3/1/2006 1122 Gerry
3/3/2006 0011 Gerry
3/11/2006 8877 James
3/11/2006 3344 Cindy
3/15/2006 8877 James
3/29/2006 1122 James

I'd like to get the number of occurence of code 8877 (column B) by James
(column C) that were made in month of March (column C). The result should be
2. Thanks in advance.

--

Dave Peterson