W
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
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