Sum a range of entries based on a multiple selection in a box

[manueslapera]

Hi, I was wondering if you guys could help me with this.

Basically, i have a huge list of customers . For each one, i have several categories of information about their purchases. The week they did it, how much they spent, and other categories.

I would like a dashboard where my I could check none of more values for each category and get the total amount of users that meet those categories, plus the total money spent by those same users, all depending of what is being selected on the boxes. I would add a button that calculates everything once the selection is made.

I am attaching a sample file as an example.

I hope you guys can help!

[Trebor76]

Hi manueslapera,

Have a look at Sheet2 of the attached where I've ditched the ActiveX ListBox controls in place of data validation lists from which the formulas in G2 and G3 are based.

Regards,

Robert