Keyword "Domestic" causing an error

Troy Lane

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.

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.