On Fri, 9 Sep 2005 10:27:28 -0500, 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

I'm interpreting this to mean that you have a column containing the
value (in this example the word "Yes") you're interested in, in say
A3:A100, and the numbers you want to average in B3:B100

So in B1 put

=SUMIF(A3:A100,"Yes",B3:B100)/COUNTIF(A3:A100,"Yes")

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________