Inconsistent totals in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1532424%22%20slang%3D%22en-US%22%3EInconsistent%20totals%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1532424%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20I'm%20not%20sure%20if%20you%20can%20help%20me%20-%20I%20am%20trying%20to%20get%20a%20consistent%20total%20for%20a%20large%20data%20set%2C%20I%20have%20never%20had%20this%20issue%20before%20however%20I%20have%20never%20really%20tried%20before%20so%20I'm%20not%20sure%20what%20I%20am%20doing%20wrong%20and%20if%20I%20have%20been%20doing%20it%20wrong%20all%20along%20-%20I%20am%20filtering%20using%20the%20code%2C%20date%20and%20amount%20-%20I%20am%20selecting%20the%20'amount'%20column%20and%20using%20the%20auto%20sum%20function%20-%20this%20provides%20a%20total%20amount%20however%20when%20I%20copy%20and%20paste%20the%20complete%20data%20set%20into%20a%20new%20workbook%20and%20filter%20it%20from%20there%20it%20brings%20up%20a%20different%20total%20to%20the%20first%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20data%20set%20has%20over%20500K%20cells%20so%20I%20am%20copying%20it%20to%20another%20workbook%20to%20remove%20the%20data%20I%20don't%20need%20without%20deleting%20that%20data%20from%20the%20original%20workbook%20-%20any%20ideas%20about%20what's%20happening%3F%26nbsp%3B%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello I'm not sure if you can help me - I am trying to get a consistent total for a large data set, I have never had this issue before however I have never really tried before so I'm not sure what I am doing wrong and if I have been doing it wrong all along - I am filtering using the code, date and amount - I am selecting the 'amount' column and using the auto sum function - this provides a total amount however when I copy and paste the complete data set into a new workbook and filter it from there it brings up a different total to the first one.

 

The data set has over 500K cells so I am copying it to another workbook to remove the data I don't need without deleting that data from the original workbook - any ideas about what's happening?  Thanks

1 Reply
Highlighted

Hello @Joe_Bloggs ,

 

With your given information I do not believe that anyone will be able to help you; someone would have to take a look at it. With what I read out of your post, I would guess there is a difference in the filtering of the two datasets.

 

Hints I can give you to explore the issue is that apart from just the sum, take a look at the amount of lines left to the aggregation after filtering is done. It sounds as if there may be some lines filtered out in the first dataset, which you copy over to the new dataset and then fail to filter out again.

 

What other symptoms are there to the issue? Do you consistently get higher or lower results in the original dataset as compared to the reduced, copied version?

 

Kind regards

Jan