Returning the average of cells, based on the value of cells in a previous column

[Kybynn]

As the title states:

I would like to return the average of a number of cells in a column, but only the cells that are next to a cell in a previous column, that displays a 1.

My explanation is terrible, but the following example displays how simple the actual problem is:

Question.xlsx

I was thinking of using VLOOKUP() in combination with AVERAGE() but am having difficulties.

Cheers

[Bob Phillips]

Just use

=AVERAGEIF(B:B,1,C:C)

[Kybynn]

Thanks!

I feel a bit ashamed, this was such an easy solution!

Thanks for the quick reply!

Cheers!