Keyword "Domestic" causing an error
I have a formula that sums Domestic and International shipments.
=SUMIFS({Shipping Cost}, {Shipping Zone}, "Domestic", {Shipping Log Range 1}, MONTH(@cell) = 1)
=SUMIFS({Shipping Cost}, {Shipping Zone}, "International", {Shipping Log Range 1}, MONTH(@cell) = 1)
For some reason the word "Domestic" is causing an Invalid Data Type Error, but I can change the word to anything else and it works. Any idea what is going on? The international formula works normally.
Answers
-
Check the other ranges on rows that contain the word "Domestic". I would start with your date range to see if any rows that contain "Domestic" either have that error, are blank, or contain a non-date value.
I don't think it is the actual word "Domestic" that is throwing the error but an issue in some other range that is being picked up when using that word.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.2K Get Help
- 452 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!