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?
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?