I am a supporter of St. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation to St. Joseph's, please.

Information on
St. Joseph's

Donation Link

If you like to create a statistic about frequencies of strings or numbers, you can use pivot tables. For smaller and less complex statistics SUMPRODUCT or even COUNTIF might suffice. Please see here for a worksheet function solution to create a list of unique identifiers and their frequency.

My thesis is that SUMPRODUCT is highly overrated (involving too much effort to maintain larger lists) and pivot tables are sometimes too complex for the casual user (and they do not automatically update with a recalculation).

So there is a gap between these two approaches which I think I can fill. I offer several versions of macros to count frequencies or to add or concatenate entries or to identify max or min for given combinations:

Pstat - Apply a function like MIN/MAX/SUM on given strings/numbers combinations with conditions applied

Cfreq - Concatenates entries (comma separated) for given string/number combinations
Mfreq - Apply a function like MIN/MAX/SUM on given strings/numbers combinations
Pfreq - List frequencies for given string/number combinations
Sfreq - Sum values for given string/number combinations

Older versions which operate on simple names or strings:

Afreq - Add numbers given for several (repeating) names.
Lfreq - List frequencies for given strings or numbers

Excursus:

CountStringCombi - Counts how often a string is followed by another string in a given range (or array).