Count Percentages in a range

  • Thread starter Thread starter tldem
  • Start date Start date
T

tldem

What I am trying to do is count percentages in a column of data that fall
within a certain range. For example, if I have 61.2%, 63%, 64.5%, 70% in a
range, I want to be able to say I have "x" number in a range between 60% -
70%. How can I do that?
 
Assuming data is in column A
=COUNTIF(A:A,">0.6")-COUNTIF(A:A,">=0.7")
Note that this excluded 60.0% and 70.0%
 
Thanks Luke but it didn't seem to work. It's counting all the numbers in
Column A versus only those in the parameter. If I have 10 numbers in the
column, it tells me that there are 10 numbers in the parameter; not the
number that falls in between the paramenter.
 
Back
Top