I want the functions MATCH, INDEX, and AVERAGE to ignore hidden rows, for the
data range specified.

In addition, worksheet functions containing MATCH will be named, and names
inserted in INDEX. (I have found that, when specifying data ranges for
charts, using names often negates the hiding of rows).

Can it be done?