Forum Discussion
Wenn-Function
I am learning for school and had 4 mental breakdowns.
Can anybody help, because i thougt the formula is correct
2 Replies
In English:
=AVERAGEIFS(C2:C11,B2:B11,">9")
In German:
=MITTELWERTWENNS(C2:C11;B2:B11;">9")
if the values in column B are >=9, the respective values from column C are to be added. At the end the added values have to be divided by their number to get the average.
