Forum Discussion
Addition of automatically sorted numbers
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 ...
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.