AVERAGEIFS in Excel 2003

[doublediamond111]

A B C
1BR Q2 $50
2BR Q2 $60
2BR Q4 $70
1BR Q1 $40

I need to get the average cost if it's a 1BR in Q2
Help please...

 

[barry houdini]

You can use an "array formula" in place of AVERAGEIFS, i.e.

=AVERAGE(IF(A1:A10="1BR",IF(B1:B10="Q2,C1:C10)))

formual needs to be confirmed with CTRL+SHIFT+ENTER so that curly braces like { and } appear around the formula in the formula bar

 

[doublediamond111]

works great, thanks.