View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tonso Tonso is offline
external usenet poster
 
Posts: 90
Default 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