Thread: function contif
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default function contif

Checks the range A2 - A10 for numbers =5 and <=20.
=COUNTIF(A2:A10,"=5")-COUNTIF(A2:A10,"20")

Mike

"IsaÃ*as." wrote:

I´ve a list of numbers and want to use the count how many of this is within
the ranges