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!!