#Invalid Data Type issue

Hello!
I have a sheet that is calculating completed projects YTD for each Project Manager. I have used the following sheet summary formula for 6 PMs, and it seems to work correctly, but when I used it for the 7th PM it gives me the #INVALID DATA TYPE error. I can't figure out what the difference is. Below are the two formulas. What am I missing?? I can't figure out why it would throw the error on just one.
working formula:
=COUNTIFS([Project Manager]:[Project Manager], "Amanda Thom", [Project Status]:[Project Status], "Complete", [Due Date]:[Due Date], YEAR(@cell ) = YEAR(TODAY()))
#INVALID DATA TYPE Error Formula:
=COUNTIFS([Project Manager]:[Project Manager], "Many Wyatt", [Project Status]:[Project Status], "Complete", [Due Date]:[Due Date], YEAR(@cell ) = YEAR(TODAY()))
Answers
-
@Vanessa T. where you have 'Many Wyatt' in the 'Project Manager' column is there any extra keystrokes, i.e., a space too many perhaps?
- 'Many Wyatt'
- ' Many Wyatt'
- 'Many Wyatt '
?? -
@PeggyLang no, I checked that I didn't see any extra keystrokes
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!