Discussion Re: Addition of automatically sorted numbers in Excel
https://techcommunity.microsoft.com/t5/excel/addition-of-automatically-sorted-numbers/m-p/2266722#M96037
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.Sun, 11 Apr 2021 16:48:37 GMTSubodh_Tiwari_sktneer2021-04-11T16:48:37ZAddition of automatically sorted numbers
https://techcommunity.microsoft.com/t5/excel/addition-of-automatically-sorted-numbers/m-p/2266607#M96033
<P>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. <BR />Example: On the left are the drivers and on the right side the constructor. One team is one colour!<BR /><BR />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).<BR /><BR />Now to my question: Is there a way, that Excel sums up the right numbers, when they are sorted automatically? <BR /><BR /><BR /><BR /></P>Sun, 11 Apr 2021 15:44:45 GMThttps://techcommunity.microsoft.com/t5/excel/addition-of-automatically-sorted-numbers/m-p/2266607#M96033Jase352021-04-11T15:44:45ZRe: Addition of automatically sorted numbers
https://techcommunity.microsoft.com/t5/excel/addition-of-automatically-sorted-numbers/m-p/2266722#M96037
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.Sun, 11 Apr 2021 16:48:37 GMThttps://techcommunity.microsoft.com/t5/excel/addition-of-automatically-sorted-numbers/m-p/2266722#M96037Subodh_Tiwari_sktneer2021-04-11T16:48:37Z