Office challenge: How do you count the results of a filtered set?

In this week's Office challenge, tests your Excel skills by providing a solution that can count filtered rows.

Last week's challenge asked for a dynamic counting function. The CountIf() function we used works fine, unless you decide to filter the set and you want a count of the results! The CountIf() evaluates the entire data set, not a filtered set. Using last week's sheet, how would you return the count of a filtered set? You can use any feature you want - no restrictions. This doesn't have to be hard - and there's your clue!