counting occurances relative to another column
Posted on 2011-10-30
I have 2 columns of data next to each other, and they are lined up so i have column A which is decimal number and column b has a key word in it (either "good" or "bad")
I want to find whether the number in column A is between 0.5 and 1, also whether the keyword in the other column is "bad"
So far i have this to find the numbers beween a certain range:
But im not sure how to find if the keyword in the second column is equal to "bad"