I have a Google Sheet document with around 100 rows. I have several filters set up to view different collections of data.
I'm trying to create an automatic formula which updates results based on the collection of data being displayed at that point in time. ie. Col A = supermarket, Col B = Location of supermarket, Col C = cosmetics available in stores, Col D-I = spend by month. (example only)
I want to filter multiple variations and have the data automatically update based on what's displayed. Is there a way to do this?