Harlan Grove wrote...
....
Move to cell E9 in the result worksheet and change Domenic's MMULT3
defined name to refer to

=--(MMULT(--(Results=Sheet2!D$2),TRANSPOSE(COLUMN(Results)^0)) 0)
...

Actually make MMULT3 refer to

=--(MMULT(--(Results=D$2),TRANSPOSE(COLUMN(Results)^0))0)

i.e., don't include a worksheet name when defining MMULT3. Excel will
refer to the active worksheet automatically.

Maybe this time I'll get it right. With cell E9 the active cell, make
MMULT3 refer to

=--(MMULT(--(Results=E$2),TRANSPOSE(COLUMN(Results)^0))0)