Reports

How can I achieve with an ARRAYFORMULA that also the range is increasing as in a drag-downed references? All should increase if there is no "$" sign before them like this:

=COUNTIF(T$2:T2;T2)
=COUNTIF(T$2:T3;T3)
=COUNTIF(T$2:T4;T4)

This

=ARRAYFORMULA(COUNTIF(T$2:T2;T2:T))

Counts as this equivalent drag-down formula:

=COUNTIF(T$2:T2;T2)
=COUNTIF(T$2:T2;T3)
=COUNTIF(T$2:T2;T4)

This one

=ARRAYFORMULA(COUNTIF(T$2:T;T2:T))

Counts as this equivalent drag-down formula:

=COUNTIF(T$2:T;T2)
=COUNTIF(T$2:T;T3)
=COUNTIF(T$2:T;T4)

Any hint is welcome how to increase also the range and achieve the first pattern with ARRAYFORMEL.

79753351