View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joes
 
Posts: n/a
Default Excel COUNTIF Function - a range as criteria ?

Ok I found the answer after a while by myself. COUNTIF delivers here an
array back. This array counts the number of each value in the rage
which have been passed as criteria. To debug the array use the INDEX()
function.
i.e.
=INDEX(COUNTIF($A$1:$A$9;$A$1:$A$9);1;1)
=INDEX(COUNTIF($A$1:$A$9;$A$1:$A$9);1;2)
etc..

regards
Mark Egloff