I think I'd us a Pivot Table for that.

Let us know if you need help setting it up.

--
Regards,
Ron