averaging ranges

[MMM]

as an example. If i was trying to average the $ value of sales based on the #
customers that walk through the door:
column A (#guests): Column B ($ sales)
22 $100
40 $200
41 $250
65 $400
72 $800
92 $1,000
i would like to know the average if the number of guests is less 40 (<40).
This one worked for me:
=AVERAGEIF(A1:A6,"<41",B1:B6)
Now i would like to know the average if the # of guests is between 40-70. My
general reasoning thought =AVERAGEIF(A1:A6,"41<70",B1:B6). However, that did
not work and i curious to the step i missed.

Thank you all for your help.

 

[מיכ×ל (מיקי) ×בידן]

Try the Array formula:
=AVERAGE(IF((A1:A6>=40)*(A1:A6<=70),B1:B6))
Micky

 

[מיכ×ל (מיקי) ×בידן]

If U R not familiar with Array Formulas -
Type the Formula and press CTRL+SHIFT+ENTER at the same time rather then
just ENTER.
This will add curly braces { } around the formula.
Micky