View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mimi Mimi is offline
external usenet poster
 
Posts: 26
Default COUNTIF for criteria in two separate columns (Excel 2003)

I want to count the yes's and no's in column B for each department in column
A. So, if I have 10 unique names in column A, I want to know how many no's
for a particular name, and how many yes's for that same name.
I am new to Excel functions.
Thanks in advance for your help.
Mimi