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!