An alternative approach to construct the matrix could be this:
=LET(x,A50:T68,FILTER(FILTER(x,BYROW(x,LAMBDA(a,COUNTIF(a,)<>COLUMNS(x)))),BYCOL(x,LAMBDA(a,COUNTIF(a,)<>ROWS(x)))))
or whatever your relevant input range is.
That should filter out only if all values are zero, but not if the sum is accidentally zero.
How to point values A117:A135 to be filled in H4:H22 in that order if F4:F22 are filled.
I don't understand what that means.
What exactly is the required output under what scenario and what is the logic employed?
Bookmarks