R
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
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