Column A1:A10 has a 0 or 1 in each cell, Column B1:B10 has numbers. I want
to be able to select the 0 (zero's) in Column A and AVERAGE only those
numbers at right in Column B.

I tried AVERAGE(IF(A1:A10=0,B1:B10) but got an average of all the numbers
in Column B, not just those at the right of 0.

Hi

=SUMIF(A1:A10,0,B1:B10)/COUNTIF(A1:A10,0)

Cheers
JulieD

"Hague2" wrote in message
...
Column A1:A10 has a 0 or 1 in each cell, Column B1:B10 has numbers. I
want
to be able to select the 0 (zero's) in Column A and AVERAGE only those
numbers at right in Column B.

I tried AVERAGE(IF(A1:A10=0,B1:B10) but got an average of all the numbers
in Column B, not just those at the right of 0.

Your formula is fine, but must be array entered (Ctrl-Shift-Enter) to work.

Jerry

Hague2 wrote:

Column A1:A10 has a 0 or 1 in each cell, Column B1:B10 has numbers. I want
to be able to select the 0 (zero's) in Column A and AVERAGE only those
numbers at right in Column B.

I tried AVERAGE(IF(A1:A10=0,B1:B10) but got an average of all the numbers
in Column B, not just those at the right of 0.