Select the All Macros smart group, then select View > Sort Macros By > Use Count. Press Command-4 to show the macro inspector, then use the arrow keys to move through the list and you can see how often each macro was used.
I wanted more control over this, though, so I wrote the Macro Usage Tracker macro which lets me decide which macros I want to track, and summarizes them in one table.
-rob.