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!