Countif

  • Thread starter Thread starter morlo
  • Start date Start date
M

morlo

I want to use the countif function with a dependance on another cell but it
doesn't seem to want to work.

I have a column with around 40,000 different entries, all of which are
percentages. I want to know how many of each of these lie in particular
bands.

ie how many are in the range 3% to 5%. due to the number of bands i'm
looking at I hoped there was a formula that I could use to link to some
cells., as opposed to doing somehing like
=countif(A:A,"<5%")-countif(A:A,"<3%")

Is this possible?
 
Try this:

B1: 3%
C1: 5%
D1: =COUNTIF(A:A,"<"&C1)-COUNTIF(A:A,"<"&B1)

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
If cell C2 contains your minimum (0.03) and C3 the maximum (0.05),
=COUNTIF(A:A,"<" & C3) - COUNTIF(A:A,"<" & C2)
 
Back
Top