Syntax for IF function

[Sarah]

I would like to average the values in column B that lie between 2 value
in column A. What I have so far is =average(if($A3:$A100, ...value i
column A is less than 46 and greater than 34..., "" ""). I have bee
unable to express the second term with the correct syntax. I assume
that it would be ,<46>34. So what is it?
Thank you in advance

 

[Don Guillett]

this idea?
=AVERAGE(IF((C1:C21>2)*(C1:C21<5),C1:C21))
of course you realize that this is an array formula that must be entered
using ctrl+shift+enter