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

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.


Thanks

Answers

Sign In or Register to comment.