Extract Data Based on a Drop Down List - Deselect Option

[researchguru]

Hi there,

I found this spreadsheet containing a drop-down list that extracts data based on the selection in Cell H4 and H6

However, say you selected both filters, is it possible to 'deselect' one over the other and have the data shown based on this. (Example: Have Alabama selected, but I want cell H6 deselected to just show all 'Alabama' results) Ex. You want to filter the table to just 'branch', without removing the 'products' drop down menu cell.

Additionally, is there a way to deselect both 'Branch' and 'Products' drop down at the same time to show all the data.

Image provided. Many thanks!

 

[Legacy 143009]

Let say Branch cell is G4 and Products is G6. First sales row (D5 I guess) formula will be

=IF($G$6="",SUMIF($B$10:$B$20,$G$3,$E$10:$E$20),"rest of your old D5 formula")

Other cells will be relatively similar. I hope you can manage.