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.