Countif with Checkboxes

Lori Khoury

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

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