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
 10.7K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!