Count and Match

I am trying to count all the In Progress and Not started projects for each manager.

This formula is giving me per cell number... I am guessing its not adding up all the in Progress project or Not started

=INDEX({Engagement Data - Not Started}, MATCH([Team Manager]@row, {Engagement Data Manager}, 0))

Engagement data sheet has the details of the not started projects with the manager name.

I am counting on another sheet, all the NOT started projects on engagement data sheet.. for the Manager on Team Manager column in the range of engagement data sheet Manager column.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you able to provide some screenshots for reference? It sounds like you are going to want a COUNTIFS.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.