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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!