COUNTIF using arrays

[YasserKhalil]

Hello everyone
I am searching for UDF that do the same as COUNTIF but within arrays
I would store A2:E20 in an array and rely on the udf to do the countif or countifs
If possible I would like it to be more flexible to deal with one criteria or two or more ..
I imagine CountifsInArray(array,col num in array,criteria1,col num in array,criteria2 ...here if possible to be as COUNTIFS)
Here's sample to work on
Thanks advanced for help

Test

 

[svendiamond]

How does COUNTIFS not suffice in your scenario?

 

[YasserKhalil]

COUNTIFS is Ok and I know how to use it
But I would deal with arrays not ranges if possible

 

[Aladin Akyurek]

COUNTIFS is Ok and I know how to use it
But I would deal with arrays not ranges if possible

Care to provide a formula example where COUNTIFS can't do what you want?

 

[YasserKhalil]

Thanks for reply
The issue is not a problem with COUNTIFS itself
I can use it in worksheet directly and also using worksheet function built in feature
I have vba array which is a result of many operations and I don't deal at this point with ranges ..I am dealing with the arrays so I think of UDF to do the same task of COUNTIFS but to deal with VBA arrays

 

[AliGW]

Where in your test file are the expected outcomes? I can see where you have used COUNTIFS formulae, but what is the ultimate aim here?

 

[YasserKhalil]

Thanks for reply
The ultimate aim in this line
I imagine CountifsInArray(array,col num in array,criteria1,col num in array,criteria2 ...here if possible to be as COUNTIFS)
Simply the same as COUNTIFS but to refer to an array not to a range >> That's all

 

[AliGW]

Please SHOW us what your expected outcome is, not your theory about how to get there.

 

[YasserKhalil]

Have a look at this code

Sub Test()    Dim arr
    arr = Range("A2:E20").Value
    
    '=COUNTIF(B2:B20,"A")
    'This is used with ranges ...
    'Imagine ::::
    MsgBox COUNTIFINARRAY(arr, 2, "A")
    '>> 2 is the second column in the array and "A" is the criteria ..
End Sub

 

[svendiamond]

You're still not providing actual expected results from this! Literally give us an example of a COUNTIFS and the result it would return!

Regardless, there is no difference between =COUNTIFS(B:B,"A") and your theoretical =Countifsarray(array, 2, "A") they would both just be counting the appearances of "A" in that column.