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)

"morlo" wrote in message
...
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?

If cell C2 contains your minimum (0.03) and C3 the maximum (0.05),
=COUNTIF(A:A,"<" & C3) - COUNTIF(A:A,"<" & C2)


"morlo" wrote:

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?

=COUNTIF(A:A,"<" & 5%)
where the 5% is OUTSIDE the double quotes.
--
Gary''s Student - gsnu200772