AVG(COUNTIF) question

Will.Dennis

I am not a programmer and am trying to build a dashboard, but I need to figure out how to do a an AVG calculation.

Can someone help me with the formula?

I need to calculate the Average % Complete grouped by primary Assignment.

For Instance:

=AVG(% Complete) where Primary Assignment = "Business"

=AVG(% Complete) Where Primary Assignment - "Technology"

Any assistance would be greatly appreciated.

Antonio Figueroa

Try using an AVERAGEIF() formula

=AVERAGEIF([Primary Assignment]:[Primary Assignment],"Business",[% Complete]:[% Complete])

then you would have to make the same formula for "Technology"

Will.Dennis

When I put in that calculation it is saying #unparseable.

=AVERAGEIF([Primary Assignment]:[Primary Assignment],"Business", [% Complete]:[% Complete])

Siva Bala

Is it possible to have multiple criteria instead of just one?

Paul Newcome

Are you able to provide a screenshot of the formula that is throwing the error directly in the sheet similar to the screenshot below?

Will.Dennis

Here you go.

Paul Newcome

@Will.Dennis The formula in your most recent screenshot has a few issues with it. Aside from the syntax issues, it also looks like you are referencing two different sheets?