SUMIF reference another sheet does not provide expected results
I am having difficulties with getting the expected results from the SUMIF formula that pick ups the sum of the inventory sum (calculating the sum, per article, where the condition is the bar code reference,
This is the syntax I am using in the columns highlighted in yellow:
=SUMIF({cdigo barras arquivo}, "[Código de Barras]@row", {Qtd arquivo})
where :
{cdigo barras arquivo} is the range for bar code reference in the sheet of movements of stock from the archive room "Movimentos de Stock Arquivo".
{Código de Barras]@row is the criterium I want to use as condition for the sum.
{Qtd arquivo} is the range for the quantities captured in the sheet of movements of stock from the archive room "Movimentos de Stock Arquivo".
Data base of products (Base de dados artigos de stock) is where I want to capture the results: has the columns Bar Code number (Código de Barras) , the product designation (artigo), family/category of product (familia), unit (unidade) and the column actual archive stock (Stock Atual Arquivo)
I have a different sheet for the Stock movements (where it is recorded all entries and exists of stock via for using a bar code). This sheet has the columns Bar Code, Designation, Quantity).
Can somebody help me understand why this is not reverting expected results? For the reference 1000387 Separadores 1/15, I would expect the quantity would not be zero, but 9 un.
Thanks in advance.
Answers

Try removing the quotes from [Código de Barras]@row:
=SUMIF({cdigo barras arquivo}, [Código de Barras]@row, {Qtd arquivo})
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 200 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!