=SUMPRODUCT(SUBTOTAL(9;OFFSET($...

Dumb question - how are you using semi colons to separate arguments of a function? Is that a regional setting?