Countif with Checkboxes

03/22/18 Edited 12/09/19

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")

Popular Tags:

Comments

  • Mike WildayMike 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")

Sign In or Register to comment.