Syntax for IF function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sarah - 31 Jul 2006 12:38 GMT

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

--
Sarah

Reply to this Message

Don Guillett - 31 Jul 2006 13:57 GMT

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

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>
> I would like to average the values in column B that lie between 2 values
[quoted text clipped - 3 lines]
> that it would be ,<46>34. So what is it?
> Thank you in advance.

Reply to this Message