Addition of automatically sorted numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-2266607%22%20slang%3D%22en-US%22%3EAddition%20of%20automatically%20sorted%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2266607%22%20slang%3D%22en-US%22%3E%3CP%3EI%20wanted%20to%20make%20a%20table%20for%20the%20Formula%201.%20So%20on%20the%20one%20side%20I%20have%20the%20driver%20points%20and%20on%20the%20other%20side%20the%20constructor%20points.%26nbsp%3B%3CBR%20%2F%3EExample%3A%20On%20the%20left%20are%20the%20drivers%20and%20on%20the%20right%20side%20the%20constructor.%20One%20team%20is%20one%20colour!%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20problem%3A%20I%20add%20the%20numbers%20on%20the%20left%20side%20up%20and%20on%20the%20right%20side%20is%20the%20sum.%20But%20as%20you%20can%20see%20on%20the%20first%20picture%2C%20the%20numbers%20aren't%20sorted.%20When%20I%20sort%20them%20manually%2C%20the%20total%20on%20the%20right%20side%20stays%20the%20same%20(picture%202).%20But%20when%20I%20want%20them%20to%20sort%20automatically%2C%20Excel%20sums%20up%20the%20wrong%20numbers%20(picture%203).%3CBR%20%2F%3E%3CBR%20%2F%3ENow%20to%20my%20question%3A%20Is%20there%20a%20way%2C%20that%20Excel%20sums%20up%20the%20right%20numbers%2C%20when%20they%20are%20sorted%20automatically%3F%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2266607%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I wanted to make a table for the Formula 1. So on the one side I have the driver points and on the other side the constructor points. 
Example: On the left are the drivers and on the right side the constructor. One team is one colour!

My problem: I add the numbers on the left side up and on the right side is the sum. But as you can see on the first picture, the numbers aren't sorted. When I sort them manually, the total on the right side stays the same (picture 2). But when I want them to sort automatically, Excel sums up the wrong numbers (picture 3).

Now to my question: Is there a way, that Excel sums up the right numbers, when they are sorted automatically? 



1 Reply
Maybe you need to revise your Sum formula by adding a criteria in it to tell it what cells are to be added and that way even if you sort the data, the Sum formula would pick up the correct cells and add them. I suggest you to use SUMIF formula and add a criteria column which can be used in Sumif formula.