Incorrect Argument

Mike B

Any idea of what I'm doing wrong with this formula?

=COUNTIFS({Airport}, "IAH", {Q2}, "Yes") / COUNTIFS({Airport}, "IAH", {Q2})

heyjay

Missing criteria for your second COUNTIFS Q2.

=COUNTIFS({Airport}, "IAH", {Q2}, "Yes") / 
COUNTIFS({Airport}, "IAH", {Q2},"SECOND CRITERION HERE")

heyjay

Missing criteria for your second COUNTIFS Q2.

=COUNTIFS({Airport}, "IAH", {Q2}, "Yes") / 
COUNTIFS({Airport}, "IAH", {Q2},"SECOND CRITERION HERE")

Mike B

Got it. Thanks!!!!!