AVERAGE a range in a column if another column's range equals a val

[bob$]

AVERAGE a range in a column if a a value in a different column equals "1"

 

[Jay T. Emory]

Have you tried SUMIF / COUNTIF ?

hth,
jay

 

[T. Valko]

Try this array formula** :

=AVERAGE(IF(A1:A10=1,B1:B10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

 

[Shane Devenshire]

Hi,

In 2007:

=AVERAGEIF(D14,1,A1:A4)

Where D14 contain the numbers you are looking for and you want to average
A1:A4.


In 2003:

=SUMIF(A1:A8,1,B1:B8)/COUNTIF(A1:A8,1)

in this case the 1's are in column A and the numbers you want to average in B.