Hello,
see attached spreadsheet. I have two columns with criteria and one column with values. I want to calculate the average. That works for all values, that works with one condition. But I am struggeling to use multiple filters. So only the average if the first criteria is a AND the second criteria is 1. I tried to use AND as key word, I tried to have a filter in a filter, but it all fails. The official help has only one simple filter FILTER function
Thanks!
multiple_conditions.ods (16.8 KB)