Countif for top level ident only

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

Project grab.png

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

Find more posts tagged with

Countif

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.