View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ccKennedy ccKennedy is offline
external usenet poster
 
Posts: 13
Default count entries that equal one criteria if another column meets anot

hi,
i'd like to use the countif feature but only if another column meets another
criteria.
Example:
A B
Product Jan
Personnel Feb

so, i want to know how many times "Product" occurred in Jan, how many times
"Personnel" occurred in Feb, etc.
help?