=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