I have the following array formula dragged across several columns,
which works a treat, but the data may be filtered by various criteria
and there's the problem - It doesn't ignore hidden values.

=SUM((NR_DataType_List=
$AC77)*(INDIRECT(ADDRESS(NRc_TopRow,COLUMN())):IND IRECT(ADDRESS(NRc_BotRow,COLUMN()))))

I've tried modifying it to use SUBTOTAL e.g.

=SUBTOTAL(109,(NR_DataType_List=
$AC77)*(INDIRECT(ADDRESS(NRc_TopRow,COLUMN())):IND IRECT(ADDRESS(NRc_BotRow,COLUMN()))))

....but this just gives me a 'The formula you typed contains an error'
message. Can SUBTOTAL even be used in an array formula? Is there a way
to make this work?

NR_DataType_List is a dynamic named range which sizes itself to a list
of datatypes in column A
$AC77 contains a fixed datatype (other rows to which the formula is
copied contain other datatypes)
NRc_TopRow is a defined name returning the top row of NR_DataType_List
NRc_BotRow is a defined name returning the bottom row of
NR_DataType_List
The COLUMN below the formula, adjacent to NR_DataType_List contains
the numbers that are to be summed.