SumIf Formula

Sara Horn

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!

Paul Newcome

You need to use a SUMIFS (with the S on the end) and remove the final range.

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

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response as "helpful" so that others searching for a similar solution can know that one may be found here.

Paul Newcome

You need to use a SUMIFS (with the S on the end) and remove the final range.

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

Sara Horn

THANK YOU!!!!!!

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response as "helpful" so that others searching for a similar solution can know that one may be found here.