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:A915,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