Apr 11 2021 08:44 AM
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?
Apr 11 2021 09:48 AM