SumIf Formula

I'm trying to sum an amount column if 2 pieces of criteria from 2 different columns are met and I keep getting #INCORRECT ARGUMENT SET. Here is my formula, any help would be greatly appreciated!

=SUMIF(Amount:Amount, [GL Code]:[GL Code], "7250 - Travel", [User Last Name]:[User Last Name], "HORN", Amount:Amount)

Thanks in advance for any suggestions!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!