KevinSue1957
New Member
- Joined
- Feb 9, 2015
- Messages
- 4
- Office Version
- 365
- Platform
- MacOS
Hi, I hope somebody can help me please. I'm trying to create a dashboard and count using COUNTIFS but I don't know how to stop duplicates. For example I have a sheet of people and projects but I want to count only 1 project although I have 2 leads on the project. I have tried using =COUNTIFS('Overall Data'!N:N,"Y",'Overall Data'!K:K,">31/03/2020",'Overall Data'!L:L,"<31/03/2021") but because more than one person is on the project and we have to put the number of the project against anybody on it, it keeps adding up the list of people on the project. I only want it to count one project to many people on it dependant on the criteria. Thanks.