Keyword "Domestic" causing an error

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!