I have 6 tables in a sheet represeting monthwise region to region wise,citywise and sales executive wise.i just pulling data to the another sheet to show the values using if and index/match formula function.if we select citywise through data validation list. It showing particular value. Is there any way to convert this data validation to check box or listbox where we can select multiple items and the main sheet should show sum of the value(region wise).