for "3":

Application.WorksheetFunction.CountIf(Selection, "<" & 3)



On 23 Mar, 21:38, avi wrote:
Hello,

I have an array (Array1) of values derived from an Excel range

Is there some function for knowing the number of items smaller than a
certain value without looping (something like CountIf for a range)?

Thanks
avi