Countif with Checkboxes

Lori Khoury
Lori Khoury ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I need help doing a countif with checkboxes.  I have a formula

I need to countif in column Project if it has a value of Yes and column Parent Task is check.   I also need it to countif column Project also has a value of partial.  This formula worked until I tried to add the Parent Task column equaling 1.  Anybody know what I am doing wrong?


=COUNTIF(Project1:Project298, "Yes", [Parent Task]1:[Parent Task]298, 1) + COUNTIF(Project1:Project298, "Partial")



  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Hi Lori, you are really close. Your first countif has multiple criteria which would call for countifs. Try that? 

    =COUNTIFS(Project1:Project298, "Yes", [Parent Task]1:[Parent Task]298, 1) + COUNTIF(Project1:Project298, "Partial")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!