How do I - formula ques

03/22/18 Edited 12/09/19

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?

Comments

  • Mike WildayMike Wilday ✭✭✭✭✭

    =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. 

Sign In or Register to comment.