COUNTIF Help
I have a column where I am calculating the growht rate of a number and
formatting the reults to show a % with no decimal places. And in this column
I am trying to find out which % values occurs the most.
In my column 1 is the raw numerical data.
In my column 2, I am calculating the % growth of the data in column 1. I
have formatted the column 2 data to display % with no decimal places. So my
column 2 data looks as follows
15%
15%
12%
17%
17%
19%
9%
15%
9%
11%
When I try to use the function COUNTIF(B4:B14, 15%), I get a value of 0.
When I hardcode the % values in the cell B4 - B14 and then apply the COUNTIF
formula I get an accurate value of 3.
Can anyone help me determine how I can apply the COUNTIF function to my %
formual cell range.
Thanks.
Roy.
|