Conditional Average

M

MEK911

Hi Everybody,

I am trying to do a conditonal AVERAGE on an excel spreadsheet and a
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.

-me
 
R

Richard Buttrey

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
Click to expand...

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
__________________________
 
M

Max

One way ..

Assume you have numbers in A1:A10,
and certain cells marked as "X" within B1:B10

We could put in say, C1, and array-enter the formula
(i.e press CTRL+SHIFT+ENTER):

=AVERAGE(IF(B1:B10="X",A1:A10))

which will evaluate the average of only those numbers in col A
corresponding to the "x" marked in col B
 
D

David Billigmeier

Without knowing your exact cell references I'll just use row 1 for the check
and row 2 as the corresponding numbers to average, in that case:

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

Array formula so enter with Ctrl+Shift+Enter
 
Top