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"...
=SUMPRODUCT((J16:EX16=1)*(MOD(COLUMN(J:EX),4)=2))Not sure what you exactly want to do but this formula updates J16:EX16 to J17:EX17 if you fill it one row down. And the MOD(COLUMN(J:EX),4)=2 only includes columns J, N, R, V.... in the calculation. Can you share one of your formulas that update the cell references fine in the same sheet?