One way,
=SUMPRODUCT((A1:A100=0.9)*(A1:A100<=1.1))
Regards,
Alan.
"KG" wrote in message
...
For a range of cells containing percentages, how can I use COUNTIF to
count
those cells whose values fall between 90% and 110% ?