How do I  formula ques
Options
tcanelli41471
✭✭✭✭
I have a formula =COUNTIF(Age8, >65) which is working, but I want it to only give me a count if a certain checkbox field is checked. Is there a formula for this?
Tags:
Comments

=Countifs(Age:Age, >65, [checkbox column name]:[checkbox column name], 1)
This would count the age over 65 if the checkbox column where there is an age greater than 65 is checked. Checkboxes that are checked have the value of 1, unchecked as the value of 0.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!