=AVERAGE(IF(1:1="value to check",2:2,""))


--
Regards,
Dave
<!--


"MEK911" wrote:

>
> Hi Everybody,
>
> I am trying to do a conditonal AVERAGE on an excel spreadsheet and am
> stuck...What I would like to do is check a one row for a certain value,
> and if true, AVERAGE the corresponding values on another coumn.
>
> Is this possible? thanks.
>
> -mek
>
>
> --
> MEK911
> ------------------------------------------------------------------------
> MEK911's Profile: http://www.excelforum.com/member.php...o&userid=27115
> View this thread: http://www.excelforum.com/showthread...hreadid=466285
>
>