Thread: COUNTIF Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cesar cesar is offline
external usenet poster
 
Posts: 43
Default 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.