COUNTIF with 2 conditions

Daniela Makowski

I want to count the # of projects in a sheet that are 'in progress'. there is a project status column; however the projects have children and i only want to count the # of parent projects in work without adding up their children. I was thinking of maybe doing a COUNTIF with 2 conditions, condition 1) countif 'in progress', condition 2) count only if column x is not blank.

Column X is the project ID number so it would be blank for the children but not the parent. How do I write the syntax?

 

Thanks 

Stefan 7k

Hi, 

try this:

=COUNTIFS([PROJECT No.]:[PROJECT No.], <>0, [LV-1 Project Status / LV-2 Deliverable Status]:[LV-1 Project Status / LV-2 Deliverable Status], "In Progress")

 

Hope this helps.

Mike Wilday

HI Daniela, 

You can learn a lot about the individual formulas and find a full list here: 

https://help.smartsheet.com/functions

Daniela Makowski

it worked!! thank you!