How can I do such a "countifs"(excel) process in Matlab?

How can I do such a "countifs"(excel) process in Matlab?

Answer 1

[Stephan]

You do it by logical indexing:

A = randi(10,1,15)
CountIf = numel(A(A>5))

gives:

A =

     9     7     4    10     1     5     4     8     8     2     5     5     7     8     8


CountIf =

     8

Answer 2

[Simon Fu]

Another way is to take advantage of the fact that logical in MATLAB has the value of 1 for true, and 0 for false.

So, using sum function would gives the same result as the previous answer of using numel; i.e.:

A = randi(10,1,15)
CountIf = sum(A>5)

gives:

A =

     9     7     4    10     1     5     4     8     8     2     5     5     7     8     8


CountIf =

     8

Answer 3

[Saad Arshad]

The best way to perform the equivalent of a COUNTIFS function in MATLAB is to first convert your data into a table and then use the GROUPCOUNTS function. Details: https://www.mathworks.com/help/matlab/ref/double.groupcounts.html