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"