Hi Jennifer,

In which cells are these averages causing an issue? I can only fine one =AVERAGE() formula (in cell A7) which in itself confuses me.
There are some formulas that are performing an average type function (cells D9 & G9 for example).

Without knowing what exactly you're trying to accomplish and what the expected results should be it's difficult to provide a solution.
However, perhaps =AVERAGEIFS() could be a help to you here.

Let us know a little more info on the intended outcome and we'll go from there.

BSB