G Sheet – Array Formula – count occurrences value in a list?

I am trying to convert the formulas below in an array formula in order to count the occurrences of a value in list of items.

Example:

enter image description here

Any help?

>Solution :

try this out:

=INDEX(IF(A2:A="",,COUNTIFS(A2:A,A2:A,ROW(A2:A),"<="&ROW(A2:A))))

enter image description here

Leave a Reply