I would like to count the number of non-empty cells in a range that depends on the row number. I've tried
counta(row()+3:row()+4) which always returns 1 as does
counta(row():row()) (where I would have expected a circular dependency).
counta(12:12) works fine, as does
How do I make a range that is dependent on