Need to create a countif formula to count repeated values in table. Is this possible/how?

Doesn't a summary report by definition filter out duplicates, similar to a pivot table in excel? What I need are the values the summary report summarizes (e.g. John Smith appears on 12 records) to be reportable and dynamic to add new records meeting criteria.

A field to say the value in the field X appears Y amount of times in the whole table.

I can solve this by exporting the Summary Report to a new Table, but then I lose the ability for it to update automatically.