Thread: HELP! countif
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default HELP! countif

Sounds like an array formula to me

=sum(IF(C6:C600="Peach",IF(E6:E600,"6",1,0)))

enter as ctrl shift enter - NOTE that you need to have an actual range
for this to work (hence my C6:C600 instead of just C or C6)