If criteria from 2 columns is met, pull the avg of a third column

sammmm

I need the avg of the "% to complete" column if the "project" column is checked and the "Law" column = 1. It keeps giving a divide by zero error. When I tried it with count instead of avg, it is only showing a count of 1 even though many rows meet the criteria.

=AVG(COLLECT([% To Goal]:[% To Goal], Project:Project, =1, Law:Law, =1))

Thanks!

Janae G.

Your formula looks pretty good, I think the one thing that might be throwing the error is that when you have a criterion that looks at a checkbox column, you don't need the equals sign before the 1 or 0.

Try this:

=AVG(COLLECT([% To Goal]:[% To Goal], Project:Project, 1, Law:Law, =1))

Hope this helps!