I am having difficulty applying sub-total to a filtered worksheet. My
worksheet has 11 columns (6 shown in the example below). At the bottom of
the worksheet I need to be able to have multiple calculations run based on
the filters. The calculations are on text in ColK and need to give a total
utilizing the words in parenthese. These calculations need to update
automatically when the filter is changed on ColD or on ColJ (status). I am
at a loss.

ColA ColB ColC ColD ColE-ColJ ColK
2244 1 0 12/3/09 Misc. Info Control Zone Use
(Utility)
2246 1 0 12/17/09 Clear Zone
(Utility)
P2242 4 0 12/1/09 Superelevation
(Design)
2215 2 1 12/9/09 Vertical
Clearance (Design)