Hi Everyone,
As the title suggests I'm trying to create a dynamic table that filters based on multiple data validation filters.
The data in the table will be looked up from a raw data tab using SUMIFS.
I just want to be able to filter the table results based on three drop down criteria (data validation) but where it gets confusing is when you want each of the 3 filters to show "All".
I don't know how to structure a IF / SUMIFS formula for all the different combinations that the data could be filtered.
File attached with notes.
Thank you!
Bookmarks