I am working on producing stats that reference user ID's and currently
have a SUMPRODUCT expression that reads like this example: -

=SUMPRODUCT(--('Version Control'!$Y$2:$Y$8743="Version Control
Applied"),--('Version Control'!$AC$2:$AC$8743="USERID")) where the
user id is taken from a list.

The User ID would be a value in Column A and the above expression is
in the adjacent cell in Column B

Currently I have to insert the USERID manually.

This is a pain because the list can change daily and then all the
values in each SUMPRODUCT have to be manually amended, which is very
time consuming. I would like the value in A to be addressed dynaically
in the expression in B.

Cheers

Mark