Counting Children Rows if marked as Active

sophiaashepard

Hello,

I am trying to list the number of projects (AKA children rows that are marked as "Active" under Active Project/Staff) in the Number of Projects column. The formula I am using where I get #unparseable is

=COUNTIF(Children([Active Project/Staff]@row ), CHILDREN([Active Project/Staff]@row = "Active"))

SueinSpain

I think your @row is not giving the range.

I've just tried a test and here is my data and I want a count of how many Children rows = test 22

There are 6 rows with test 22 but only 5 are children

My formula is:

=COUNTIF(CHILDREN([Primary Column]:[Primary Column]), ="test 22")

and this gives a result of 5

Good luck and hope this helps

sophiaashepard

Hey Sue

I don't think that will work because I have the indentation in the Project column. That is what I am having a hard time with.

Darren Mullen

@sophiaashepard

You have the range also included in the criterion position. should just be:

=COUNTIF(Children([Active Project/Staff]@row ), "Active")