How to use SUMIFS with ranges

Anuraag

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.

Paul Newcome

Try removing the "@row"