OK it transpires something like this works:

=SUMIF(INDIRECT(J2), H6, INDIRECT(J3))

Where J2 stores the text string B2:B76 and J3 stores the text string E2:E76

I just couldn't initially understand how INDIRECT works or what it even meant.