Average IF + advanced filter ->fails

I found out, that i can avoid this by using either SUMIF(....)/COUNTIF(...) or DAVERAGE(). On the other side, both of these ways are not the best solutions...