Have you thought of using a Pivot Table.

This performs the acts of filtering, summarising and analysing without going anywhere near functions or macros.

If you've never used PTs I suggest you spend 1/2 an hour or so exploring them. You'll be pleasantly surprised at their simplicity once you understand what they're doing and you'll be able to analyse data in ways you've not even thought of yet.