Categories
October Surprise 2024

Google Sheets Query Dynamic Rance with Multiple Conditions

Hello, I am presented with the following challenge: Is it possible to create a query function with multiple dynamic ranges? I want to average the data in one column based on a few conditions. Normally I would use averageifs but the problem is that the columns may change positions so I cannot use a static reference like column A.