Syntax for IF function
 

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

Syntax for IF function
 

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

--
Don Guillett
SalesAid Software

"Sarah" wrote in message
...

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




--
Sarah