Sumifs with multiple criteria using Combobox

[A_rp]

Hi Champs, I have a dump from system where each row has multiple attributes. I have assigned different reporting levels from highest level summary to the lowest level detail. Sample data is attached. I intend to have Combobox for all these levels and bring the sum for each month based on selected item in the Combobox. Each Combobox shall also have "All" as one of the criteria. I really appreciate your help on this.

Warm Regards,
ARP

[AliGW]

Welcome to the forum!

There's a much easier way to achieve this:

1. Convert the grid to a proper Excel table.
2. Change the total line formulae to SUBTOTAL formulae using the option that excludes hidden rows (109).
3. Add slicers to filter your data.

[A_rp]

Thanks Ali for swift response. Appreciated indeed. Actually, I have huge data and multiple parameters that I am summing up and I have interactive Charts linked to the table that gets populated based on criteria selected in Comboboxes. I used simpler table for demo. Appreciate if you could re-visit based on above.

[AliGW]

Why are you trying to make it harder for yourself? This approach I have shown you will work with your more complex data and with charts. It will be far, far more efficient than trying to do this with formulae.

This is the solution I am offering and it's easy. If you don't want to learn, then that's fine.

EDIT: Have you even looked at the workbook I provided?

[rorya]

Assuming your columns don't have blanks in them, you could use additional cells that test each dropdown and if it says All, the formula returns * otherwise it returns the selected value. Then simply refer to those cells for the SUMIFS criteria.

[A_rp]

Hi Ali, I did check the workbook that you attached. Thanks for response.

[A_rp]

Thanks Rory. This is working. Your assumption that there are no blanks is quite correct.