Forum Discussion
Sum the top x% of data
I've just realized that I need the top X% based on the total height of the sections, not the number of sections, as some sections could be longer or shorter than others. Also, I could easily combine the two columns of weights into another column if that would make it easier
Thanks Again,
Michael
I figured it out, I made a reference cell which is the percent I want it to check (in this case 20%), and filled it in as 0.20, and another reference cell that is 1 minus that cell multiplied by the max height, giving us a threshold to test to. Then I made an additional column, which is an IF statement that checks the top of the section versus the threshold value, if it is larger, then it adds the two corresponding weight columns. I then just have to sum that column to get the answer.