Count de-duplicated aggregates

I have a large table with several rows hidden by removing the filters. I'm doing a total count with the following formula, which work fine.

Please Login or Register  to view this content.

I've taken remaining "Plan_Grp_Name" column over into a new tab, removed the duplicates, and now trying to count how often these occur. The table these are in is Table1. Anybody know how I might do this?