Trying to set up my Sheet Summary formulas so I can create a dashboard

Kenneth Anderson

I've been trying to set up my Sheet Summary formulas to look through one column, pick out the Not Completed projects and then take an average of the days outstanding.

Not Complete Fx: =COUNTIFS(Contractor:Contractor, "BENTON Paving", Status:Status, "Not Complete")

Unparseable Fx: =COUNTIFS(Contractor:Contractor, "BENTON Paving", Status:Status, "Not Complete"), AVERAGEIF([Days Outstanding]:[Days Outstanding])

Mike TV

AVERAGEIF only allows for 1 criteria which you haven't defined in the formula above plus you cannot string two formulas together in such a way as you're trying to do. You're going to need to set up a helper column that is something like a checkbox column with a formula. It'll check the box if it's both Benton Paving and Not Completed. Then have the summary column AVERAGEIF the helper column is checked. Do you know how to set that up or do you need help?

Mike TV

AVERAGEIF only allows for 1 criteria which you haven't defined in the formula above plus you cannot string two formulas together in such a way as you're trying to do. You're going to need to set up a helper column that is something like a checkbox column with a formula. It'll check the box if it's both Benton Paving and Not Completed. Then have the summary column AVERAGEIF the helper column is checked. Do you know how to set that up or do you need help?