Formula for a count of checkbox by a specific location

Suzanne Thompson

Hello,

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.

Paul Newcome

You have some misplaced parenthesis.

=COUNTIFS(Attended:Attended, 1, Location:Location, "Cedar Crest")

Paul Newcome

You have some misplaced parenthesis.

=COUNTIFS(Attended:Attended, 1, Location:Location, "Cedar Crest")