COUNTIFS with range in criteria?

[BatTodor]

I'm trying to count items with ranges as criteria, not a separate value.
Using win this way, it's works:
=LET(
range, INDEX(CA3#, , 54),
uniqueRange, UNIQUE(range),
positions, COUNTIF(range, uniqueRange),
changes, COUNTIFS(range, uniqueRange, INDEX(CA3#, , 16), "Yes"),
percentage, changes/positions,
transport, IF(percentage >= 0.75, "Variant 1", IF(percentage >= 0.5, "Variant 1", "Variant 1")),
table, HSTACK(uniqueRange, changes, positions, transport),
table
)

When I use same approach but in more complex formula (data generate spill range in CA3# in formula above), it's not worked:
=LET(
...
data, HSTACK(dataTable, tempTableWithHeaders, filteredData1, readyTable),

range, INDEX(data, , 54),
uniqueRange, UNIQUE(range),
positions, COUNTIF(range, uniqueRange),
changes, COUNTIFS(range, uniqueRange, INDEX(data, , 16); "Yes"),
percentage, changes/positions,
transport, IF(percentage >= 0.75, "Variant 1", IF(percentage >= 0.5, "Variant 1", "Variant 1")),
table, HSTACK(uniqueRange, changes, positions, transport),
table
)

Receiving message "A value used in the formula is on the wrong data type" on counting - positions and changes.

Any idea?

 

[BatTodor]

The only way is to output the array to a cell as a spilled range & use that.

Do you mean they are all calculated within the formula you posted? As it it does not show that.

I was think to make calculations with MAP and LAMBDA, but seems that would be slower as calculations.

Do you mean they are all calculated within the formula you posted? As it it does not show that.

Yes, all this array are calculated in the formula before
...
data, HSTACK(dataTable, tempTableWithHeaders, filteredData1, readyTable)

There are more than 40 calculations before combining dataTable, tempTableWithHeaders, filteredData1, readyTable in data array.

In any way, many thanks for information about the way of calculations in HSTACK

 

[Fluff]

In that case you will not be able to use countifs.

 

[BatTodor]

In that case you will not be able to use countifs.

It works with BYROW(uniqueRange; LAMBDA(rows; SUMPRODUCT(--(range = rows))))