Hello Thomas,
Instead of exporting to Excel you could use the Subject Bibliography command to produce a type of Report but in order to get the accurate count you still will need to add the group name to a field.
You would then able to run the Subject Bibliography command on that field.
You can find out more about the Subject Bibliography feature on our website: