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?

  • 1
    Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    May 19 at 2:49


Browse other questions tagged or ask your own question.