How to use SUMIFS with ranges

I am trying to use following formaula to sum all amounts in Rage 2 when the country is VN in same row of Country column (Range 5). But I am gettingt the error as #UNPARSEABLE

=SUMIFS({Sheet - Sales Pipeline Range 2}, {Sheet - Sales Pipeline Range 5}@row,"VN")

Have tried a few ways but still error, hope someone can help.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!