Microsoft

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!

About

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks