msquared99
Member
I have reports that I run from other programs/software that will only export in .xls files. I have Excel 2010 on my computer. The other day I ran a report and had a raw data tab and a summary tab. As is good practice I made sure the summary tab total matched the raw data total to be sure I had summarized all the data correctly. It was correct.
To my surprise several random rows had different values than they should have but my total check revealed my summary was good. I used SUMIFS in the spreadsheet.
In other words company ID 12345 had say $600 where it should have had $1,500 and another had say $200 when it should have had $800. Other lines had the correct totals. I verified this by looking and the invoice totals from another report.
I then went to the top of the spreadsheet and re-copied the formulas and the right totals were now where they should be.
I have also noticed this using VLOOKUP as well.
Has anyone else seen this type of issue? By the wy I have been using Excel for as long as Microsoft has had it.
Thanks,
Mike
To my surprise several random rows had different values than they should have but my total check revealed my summary was good. I used SUMIFS in the spreadsheet.
In other words company ID 12345 had say $600 where it should have had $1,500 and another had say $200 when it should have had $800. Other lines had the correct totals. I verified this by looking and the invoice totals from another report.
I then went to the top of the spreadsheet and re-copied the formulas and the right totals were now where they should be.
I have also noticed this using VLOOKUP as well.
Has anyone else seen this type of issue? By the wy I have been using Excel for as long as Microsoft has had it.
Thanks,
Mike
