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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!