Criteria question - AverageIF (if you please)

**djalexr** · 01-14-2011, 07:54 AM

Hello there,

=AVERAGEIF(C11:C251,">=6.8")

This averages all the values in the range that are greater than or equal to 6.8...

However, I wish that instead of static "6.8" it could link to another cell, A9;

i.e. to average all the values in the range that are greater than or equal to the number in A9.

=AVERAGEIF(C11:C251,">=A9") returns DIV#0.

THANK YOU!

Alex

**zbor** · 01-14-2011, 07:56 AM

Try:

=AVERAGEIF(C11:C251,">="&A9)

**djalexr** · 01-14-2011, 07:59 AM

yes mate that is exactly what I was after, cheers!!

**DonkeyOte** · 01-14-2011, 08:00 AM

And, if you want the operator to be variable also you can store the criteria as a string, eg:

Please Login or Register  to view this content.

at which point

Please Login or Register  to view this content.

so you can change the operator just as you do the value

Obviously if the operator does not change use zbor's suggestion (quicker to amend A9)

edit: on an aside it would be a good idea to update your Version in the profile (AVERAGEIF XL2007+ of course)