Count checked box if condition in another column is met


Trying to count check boxes in one column when a condition is met in another column.

=COUNTIFS(AE:AE), "Amy Coleman", (Registered:Registered, 1))

In this case, I want to look at the AE column for Amy Coleman and count the number of boxes checked in the Registered column.

It's giving me an unparseable error.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!