I am using this seemingly simple formula: =SUMPRODUCT(--(owssvr!$A:$A>=$B$1)*(--(owssvr!T:T=$B$2)))
I started in B3 and dragged it down to B30. I expected the column T to increase to column BG but stayed put at column T. Does Excel not increment if I drag down for column reference? I noticed it did increase when dragged horizontally. I would appreciate an explanation and perhaps a better way. Thank you.
I started in B3 and dragged it down to B30. I expected the column T to increase to column BG but stayed put at column T. Does Excel not increment if I drag down for column reference? I noticed it did increase when dragged horizontally. I would appreciate an explanation and perhaps a better way. Thank you.