Thread: countif & and
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charlie7805
 
Posts: n/a
Default countif & and

What am I doing wrong? I need to count the number of "Yes" in column W for
all entries with a 72 in column A

=countif(and($a$4:$a$300,72),$w$4:$w$300,"Yes"))