MS Excel 97 "countif" function

  • Thread starter Thread starter EADesktop
  • Start date Start date
E

EADesktop

I can use the Countif function if I insert a reference ie Cell A1
but if I use a function like > or < it won't work

I want to use the countif function to find cells which are greater tha
0 -10% and so on.

Can anyone help me.
 
Hi
try something like
=SUMPRODUCT(--(A1:A100>=0),--(A1:A100<0.1))

or use
=COUNTIF(A1:A100,">=0")-COUNTIF(A1:A100,">=10")
 
If you have some percentages in cells A1 through A4
you can use the following formula in Cell A5
=COUNTIF(A1:A4,">0.15")
Is this what you want?
Alok
 
Back
Top