Countif for top level ident only

Richard A

Hi,

I am trying to collate the number of project assigned to individuals by using the COUNTIF function:

=COUNTIF({Project Dashboard Range 1}, "Colin Alexander")

The problem is, that it is picking up all the names in the rows below, which are indented for the project (actions within the Project), is there a way to only count examples which are not indented (top level only)?

Thanks in advance

Monique Odom-Stearn

Hello @Richard A,

I would recommend adding a helper column to identify the level of each row (1, 2, 3, etc.), and then you can change your formula to a COUNTIFS with the additional criteria of only level 1 rows.