Countifs with unique values & dates

Hi,

I need to count the number of unique text values on any given date. I've used powerpivot (fir the 1st time!) to create a pivot chart to show me unique entries, but I now need the values on a summary table by date.
For example, how many unique people attended show1 on 25th July?

Date Type Name
25/07/2012 Show2 Mickey
25/07/2012 Show2 Donald
25/07/2012 Show1 Mickey
25/07/2012 Misc Goofy
25/07/2012 Show1 Pluto
25/07/2012 Show3 Goofy
25/07/2012 Show1 Mickey
25/07/2012 Show1 Mickey
25/07/2012 Show1 Donald

I have a summary table that shows various things so can't use a pivot. The data is already there in various pivots so I either need a formula in the summary table to get the results from the source data, or learn how to get data copied over from a pivot table where the date is picked up automatically (so on summary table I will create a new column for each date, once the pivots are refreshed I would like to copy the results from the pivot as this already has some of the info).

I hope this makes sense - my workbook is quite big so I'm hoping to not have to upload a sample if possible :$.

Thanking you in advance.
L

Thank you. Will try that and let you know...