#INVALID DATA TYPE SUMIFS function

I'm struggling to rid of my #INVALID DATA TYPE error in my function. I understand that the error means the function is trying to act on a data type that is incompatible with some part of the function. However, I have thoroughly looked through the sheet, and the sheet it is referring to, to validate the data types. Here is my function:
=SUMIFS({NCP Ext Cost ARCHIVE}, {NCP Resp Whse ARCHIVE}, [Falls City]#, {NCP QA Comp ARCHIVE}, YEAR(@cell) = YEAR([Week Start Date]@row), {NCP QA Comp ARCHIVE}, WEEKNUMBER(@cell) = WEEKNUMBER([Week Start Date]@row))
The goal of the function is to add total extended costs with three different criteria. The first two compare if the week number and year from the referenced sheet is equal to the week number and year in the row. The third criteria is if the warehouse is equal to [Falls City]# ("065 / FC").
I have made sure to set the appropriate column data types to date, and text/number.
Can anyone lend a hand? Thank you!
Answers
-
This has been resolved. There were blank fields hidden deep within the data sheet. Once deleted, the error went away.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!