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

webnntp wrote:

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

--

Dave Peterson