Use SUMPRODUCT.

=SUMPRODUCT(--(A1:A100=1),--(B1:B100="JC"))

HTH,
Elkar


"Tonso" wrote:

Using XL2002 for Window, I need to count the number of items that
match criteria in both of 2 columns. Column A contains a list of
numbers that can range from 1-12, corresponding to the month, and
column D has an individuals initials. I want to be able to determine,
for example, how many entries would match "1" in column A and "JC" in
column D. Is there a function that will do that?

Thanks, Tonso