Sumproduct Not Updating Relative Column Reference

[isadoko]

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.

 

[AliGW]

The key to this is in the word "relative". If you type =A1 into cell B1 and drag copy across, the column reference will increment, but the row reference will not. If you drag copy downwards, the row will increment but the column reference will not. So it's not correct to expect the column references to increment in your case.

You will most likely need to find a solution using the INDIRECT and/or OFFSET functions.