Help with cross-sheet sumifs

Options

Hi All,

I'm getting an #Unparseable error, and I'm too tired to see why. Any help would be greatly appreciated!

In the source sheet, I've got invoice data. In the destination sheet, I want to be able to sum all the invoices for certain Project Codes. Here's what the source sheet data looks like:

And here's what I've got for the formula in the destination sheet:

=SUMIFS({GL Amount value}, {GL Project} "P-500", {GL Project} "P-501")

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!