Forum Discussion
Relative cell reference in formula is not updating when dragging down rows
I have this formula: =SUM(COUNTIF(INDIRECT({"j16","n16","r16","v16","z16","ad16","ah16","al16","ap16","at16","ax16","bb16","bf16","bj16","bn16","br16","bv16","bz16","cd16","ch16","cl16","cp16","ct16"...
Another option:
=LET(
vector, TAKE(WRAPROWS(J16:EX16, 4), , 1),
SUM(N(vector = 1))
)I think any solution without INDIRECT is an upgrade here.