How to count number of distinct values in a range?

Problem

I've got a large table that is already organized using filters etc. I'd like to add a summary underneath certain columns that contain the number of distinct values in that column. There's no function so what can I do instead? (Excel 2003) I can't exactly use answers to this similar question because…