using the SUMIF formula to pull data from another file and display in a separate smartsheet

In Excel I can use the SUMIF formula to calculate data from one spreadsheet and show the sum in another Excel file. Excel Formula =SUMIF('2020 Data'!B:B,A5,' 2020 Data'!F:F) - Column B has Supplier List and Column F has all the amounts of spend by PO number in Column A

When I try with Smartsheet I keep getting #UNPARSEABLE or #INCORRECTARGUMENT

Name of File were data is located is Tracking

Supplier is one column

Amount is another column that I need to SUMIF based on Supplier

Storing in my Dashboard working file

Supplier Column Total Amount Column

Any help would be appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!