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.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.