Formula for a count of checkbox by a specific location
I am trying to create a formula for a specific location and completed check box. Here is my formulas. Each work separately but as I am trying to join, it does not work.
=COUNTIFS((Attended:Attended, 1),(Location:Location, "Cedar Crest"))
Thank you in advance for assistance.
Help Article Resources
Check out the Formula Handbook template!