Thread: Countif ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tomkat743 Tomkat743 is offline
external usenet poster
 
Posts: 48
Default Countif ?

How do I count the number of 2's in column A that do not have the word no in
column B? Answer = 3

A B
1 yes
2 no
2 yes
2 yes
1 maybe
2 maybe