I am trying to create a function that adds up the number of instances
in D35:J35 that are greater than 1 (effectively where cells have a
value other than blank or 0) in all sheets between Start and End. Note
I 52 sheets between these two. The formula below doesn't produce the
result I'm expecting. Have I gone wrong?

=COUNTA(Start:End!D35:J350)