Hi

I have the following data:

A B
22 70%
29 20%
22 90%
24 10%

I want to calculate the AVERAGE of the values in Column B, where Column A's
value is "22". I.e. the answer to the above example will be 80%. I have tried
the {=AVERAGE(IF(A1:A4="22",B1:B4))} but it does not work?