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

Have you tried SUMIF / COUNTIF ?

hth,
jay

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.

--
Biff
Microsoft Excel MVP


"bob$" wrote in message
...
AVERAGE a range in a column if a a value in a different column equals "1"

Hi,

In 2007:

=AVERAGEIF(D1:D4,1,A1:A4)

Where D1:D4 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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"bob$" wrote:

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