How to implement an Average If Formula

robert.hallstrom

Hello all,

I am looking to have a cell in the SOV Comp% column be averaged from every cell in the % Complete column based upon a label from a drop menu in the SOV Category column.

Any assistance would be greatly appreciated. Please see image below for reference.

Sing C

Hi @robert.hallstrom,

Looking at your screenshot I'm assuming that, for example, in row 6 (Lighting), in the SOV Comp% column, you want to average the %complete column of every row where the SOV category column = Lighting. If so, give this a try, you can convert it to a column formula.

=AVERAGEIF([SOV Category]:[SOV Category], [Task Name]@row, [% Complete]:[% Complete])

Hope that helps. Let me know if that answers your question.

Thanks!