I have two rows of visually identical numbers that are summing differently. I have tried using different sum functions, and my formulas are correct. When I subtract by one row from the other by column, they all give 0.

Some of the cells must be formatted such that they are not included in the sum. I have tried changing the formatting all cells as numbers or general, but this does not fix the problem.

Any ideas? I appreciate your help.