SUMPRODUCT - how to increment row refs by 1 when dragging across a sheet

[Sagan234]

I am trying to include an additional function in this formula:
=SUMPRODUCT((Dom_Counts!$B$2:$CY$2<>"")*(Dom_Counts!$B$2:$CY$2=Dom_Counts!B3:CY3))
in order to increment the row numbers by 1 each time I drag it over to the next column without changing the column references.

This formula is referring to another sheet that has an individual's (rows) field of work (columns) marked with a 1 (if they do not work in a field it is left blank) and counts how many fields of work two individuals have in common.

and I need to streamline the process of moving the formula across my sheet (900+ rows/columns) that looks like the one below. I can sacrifice the diagonal formatting and do that part manually later - if that helps.
ex:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Cell A1[/TD]
[TD]Carl[/TD]
[TD]Peter[/TD]
[TD]John[/TD]
[TD]Joyce[/TD]
[TD]Ryan[/TD]
[/TR]
[TR]
[TD]Carl[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Joyce[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ryan[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I have tried OFFSET a number of different ways, but just can't seem to make it work.

Thank you!