SUMIF formula

Options

I am having issues with my Sumif formula--it has always worked fine, but all the sudden is no longer working. I am trying to sum a column based off an identifying number in another column. Some rows have the same identifying number and I want them to be added together. I tried changing the [TaxID]1 to [TaxID]@row, but that doesn't work either. Any insight is much appreciated. Thanks!

=SUMIF([TaxID]:[TaxID], [TaxID]1, [Last Month's Attribution]:[Last Month's Attribution])

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!