averageif (XL2007)
 

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

averageif (XL2007)
 

Hi Rob

Try
=averageif(A5:A350,""&$A$2,B5:B350)
--
Regards
Roger Govier

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

averageif (XL2007)
 

Tx a lot - never thought of that one <BG




"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Rob

Try
=averageif(A5:A350,""&$A$2,B5:B350)
--
Regards
Roger Govier

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