<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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 &quot;good&quot; or &quot;bad&quot;)<br />
<br />
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 &quot;bad&quot;<br />
<br />
So far i have this to find the numbers beween a certain range:<br />
<br />
=COUNT(A:A)-COUNTIF(A:A,&quot;&lt;<wbr />0.5&quot;)-COUN<wbr />TIF(A:A,&quot;&gt;<wbr />1&quot;)<br />
<br />
But im not sure how to find if the keyword in the second column is equal to &quot;bad&quot;
</div>
</div>


Hi,

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:

=COUNT(A:A)-COUNTIF(A:A,"<0.5")-COUNTIF(A:A,">1")

But im not sure how to find if the keyword in the second column is equal to "bad"

counting occurances relative to another column

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.