averageif (XL2007)

[RobFJ]

I'm trying to get an averageif formula working but the criterion I'm trying
to satisfy is of a number greater than that contained in a specific cell.

=averageif(A5:A350,>$A$2,B5:B350)

I've tried all sorts of variants of syntax for the criterion with no
success. The formula will work if I put a specific value in, eg ">4".

Can SKS help out.

Tx

Rob

 

[Roger Govier]

Hi Rob

Try
=averageif(A5:A350,">"&$A$2,B5:B350)

 

[RobFJ]

Tx a lot - never thought of that one <BG>

Hi Rob

Try
=averageif(A5:A350,">"&$A$2,B5:B350)