tehneXus, thank you for this, but it is taking me a while to understand. Would you be able to help with one final iteration? I've added in a Gender drop down box (please note, I have shifted down some of the criteria in the top left corner.) Just to clarify, when only Site is chosen then a breakdown happens on everything that matches the site. When Site and Brand are chosen then a breakdown happens where site and brand matches. When Site, Brand, and Gender are chosen then a breakdown happens where all three matches. Lastly, if Site and Gender are chosen then it would breakdown where those two match. I have been trying to make these changes on my own but I am running into many errors such as "Run-Time error "9": Subscript out of range" and many many others. Please let me know if this does not make sense, and I can try and elaborate more.

Test (2).xlsm