This one has gone beyond the basic filtering that I readily know how to do. I'm sure if pressed I could figure out how to read the result of the filter into variables then put together the message box the OP wants, but I expect that many of you know better how to extract the information the OP wants and output it in a format more like what the OP wants. I also don't know and can't test what dflak's slicers can do in this regard.
https://www.excelforum.com/excel-pro...-how-many.html