View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

You could count the number = .9 and subtract the ones 1.10
=countif(a1:a10,"=.9") - countif(a1:a10,"1.1")

Or you could count the ones that are trapped between those numbers:
=SUMPRODUCT(--(A1:A10=0.9),--(A1:A10<1.1))

=sumproduct() likes to work with numbers. The -- converts trues and falses to
1's and 0's.





KG wrote:

For a range of cells containing percentages, how can I use COUNTIF to count
those cells whose values fall between 90% and 110% ?


--

Dave Peterson