Formula to only include status of parent rows and the contact assigned to them

jahmeanne

Hi folks,

I'm trying to create a COUNTIFS formula that calculates the number of "In Progress", "Issue/At Risk", "Postponed", and "Complete" statuses that a specific contact has (in this case, the user assigned in the "Lifecycle Lead Column"). The problem I'm having is that I only want to count the parent rows, not the children rows. Is there a logical way to go about this?

I should note that I've also created a helper column and have attached a screenshot of the sheet below for reference. Thanks a bunch for your time.

Paul Newcome

If you only have the contact on the rows you want to count, then you should be able to use a basic COUNTIFS.

Paul Newcome

If you only have the contact on the rows you want to count, then you should be able to use a basic COUNTIFS.

jahmeanne

Thanks Paul! Do you know the best way to do a COUNTIF on a status that would exclude the child rows? I just want the blue parent rows counted.

Paul Newcome

If you only have the contact entered in the blue rows then you wouldn't need to worry about excluding the child rows.

jahmeanne

Ah, yes you're right. Thank you so much for your help. Appreciate you!

Paul Newcome

Happy to help. 👍️