Average using Greater Than - Less Than

[webnntp]

Col A Col B
10 10
20 40
10 20
15 30
40 60
10 20
15 20
40 70
20 30

To find the average of the values in column B where column A is greater
than 15, I use the formula below:

{=AVERAGE(IF(A1:A9>15,B1:B9,""))}

How do I modify this formula or use another one to find the average of
the values in column B where column A is greater than 15 and less than
40?

Thanks

 

[Dave Peterson]

One way:
=AVERAGE(IF((A1:A9>15)*(A1:A9<40),B1:B9))
(still array entered)

 

[daddylonglegs]

Try this

=AVERAGE(IF((A1:A9>15)*(A1:A9<40),B1:B9)

 

[webnntp]

Try this

=AVERAGE(IF((A1:A9>15)*(A1:A9<40),B1:B9))

Awesome! thanks to both of you.