I have a column of data that uses a sumif to get the total of transactions by date. These totals are then index matched in the next column to a separate tab. The column where the index match is, is missing some of the totals of the sumif in the first column. It works for many of them, but is unable to read some. I have made sure the figures are in the column on the other tab where they are being matched and all formatting is the same. I have no idea why it is missing certain cells. Please can someone advise?
