Count and Match

keesuri25

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.

Paul Newcome

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