averageif (XL2007)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top