Sum values ​​based on data from another spreadsheet

foobar

Hello,

How can i use SUMIF to get the sum of the values ​​in the Portfolio sheet where the project names are the same in Project Invoices?

Thanks in advance

Julie Fortney

Here's a formula you can use in your SUM(INVOICES) column:

=SUMIF({Project Invoices - Project Name}, CODE@row, {Project Invoices - Total})

The {} indicate cross-sheet references from the Project Invoices sheet. This formula tells Smartsheet to sum the Total cells for any rows in which the Project Invoices Project Name column matches the value in the CODE column on this sheet.