Many thanks for your responseI'd use a pivot table.
thank you for your remarksWhat do they need to be aware of? You create it for them. (you can add some code to refresh it automatically if the data changes.
Your alternative is a load of array formulas pre-entered into enough cells to cope with any possible changes to your data.