MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using a range as criteria in Countif

Posted by brian on February 01, 2000 1:47 PM

Is it possible to use a range as the criteria in the
count(if(...) array function? I would like to determine
the number of occurences I have in various categories for
various process' where all process' have the same categories.
(ie:0-12, 12-15,15-20,20-24, 24+).

I have been able to use <=12 (single logical operators) but
have not been able to use multiple to bound the range.

Posted by Celia on February 02, 2000 2:59 AM

You can use the macro per the reply to your question "VBA Code For Array Formula" and just extend the number of criteria ranges.