SUMIF formula

Kacey Sappington

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])

Paul Newcome

Are you able to provide a screenshot that shows the incorrect output and the rows that should be included to generate the total?

Kacey Sappington

Not sure if this is completely helpful, but here are the columns and a few rows it is pulling from. The output I am currently getting is #ref. Thank you!

Paul Newcome

That's an odd error to be getting. What happens if you remove the / and the # from the column name? I wonder if either of those special characters being in the column name are throwing things off...