Countif with Checkboxes

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

Find more posts tagged with

Formulas

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Calculate number of days between two dates in the same column on the same sheet
Hello, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal to…
Match or Index
I am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
Workflow Generate Impact Report PDF in Impact Form Response Sheet has become invalid
Hi All, I keep getting this annoying error when I try to trigger a PDF generation. I initially set up to trigger the PDF generation to kick off once the last field the needs data is "not blank". That is when the error started. I modified the sheet and added a yes/no drop down to trigger the PDF generation when the value in…