Try this:

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=AVERAGE(IF((A1:A10100)*(A1:A10<200),B1:B10))

Biff

"Todd_Aus" wrote in message
...
I wish to average a column of values if the values in another column (same
rows) are between a specific range, eg 100 and <200.

Thanks

Todd