Hi!

Try this:

Array entered:

=AVERAGE(IF((B1:B100=1)*(C1:C100=1),A1:A100))

Biff

"vinnie123" wrote in message
ups.com...
Hi everyone

Probably a simple one.

I want to find the average of column A for the cells who's row has a
value of 1 in BOTH columns B and C.

I can get to do if for only column A and B with:
{=AVERAGE(IF($B$1:$B$100=1,$A$1:$A$100))} but can't extend this to
also IF C1:100=1 as well.

Any suggestions. Thanks!!