View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cisbell_ddess cisbell_ddess is offline
external usenet poster
 
Posts: 1
Default Conditional count

I need to count unique occurances of names in column a which satisfy
conditions in two other columns. For instance:

A B C
Smith faculty annual fund
Smith faculty annual fund
Jones faculty annual fund
Smith faculty new gift
Jones faculty new gift

The number of unique occurances of Smith in column A where column B=faculty
and column C=annual fund. The answer of course is 2, but how do I write a
formula to answer that question in a long list of data?