countif in 2 columns
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
|