Filtering out duplicates and counting whats left in Excel

[Jody72]

I've got an Excel file that lists programs by numerical file name, what machine they are for and wheter they are proven or unproven. At the bottom I have it set to count the # proven, # unproven, and then the total. I know how to filter out duplicates, but it just hides those rows and does not change my totals, which is what I need. I need to be able to hide any duplicates and have my count show only what is not hidden.

Here's an example:

ColA ColB ColC
12 Machine1 Proven
12 Machine2 Proven
14 Machine3 Unproven
15 Machine4 Proven

Total Proven: 3
Total Unproven: 1
total: 4

Results being:

ColA ColB ColC
12 Machine1 Proven
14 Machine2 Proven
14 Machine4 unproven

Proven: 2
Unproven: 1
Total: 3

The machine numbers are irrelevant, I just added those to show why there would be duplicates of filenames. Currently I'm using the COUNTIF function, but it counts the hidden rows as well as the unhidden. I'm also aware of the SUBTOTAL function, but it doesn't have a COUNTIF part. I'd like to have something that I can put in a macro or whatever and have the users run it from here on out when programs are added.

Thanks for any and all help in advance. My knowledge of something like this is virtually nil.

Jody