ExcelBanter - View Single Post

WildWill

Thanks Don!

"Don Guillett" wrote:

Try it without "" and make sure you enter using ctrl+shift+enter
=AVERAGE(IF(A1:A4=22,B1:B4))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WildWill" wrote in message
...
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?