View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Counting Multiple Instances

Try something like this:

=SUMPRODUCT((C1:C20="F")*(N1:N20="Y"))


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Curtis" wrote:

I need to count the number of times F shows in column C at the same time Y
appears in column n

Thanks

ce