Create Average if value between 2 numbers

T

Todd_Aus

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
 
T

T. Valko

Try this:

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

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

Biff
 
Top