I am trying to create a statistical table based on columns of information. The row/column identifiers of the table are also incorporated in part of the statistics of the table. I have three columns of information including a min, max, and middle statistics. Keep in mind that while i am showing only one example of the numbers there are actually hundreds of occurrences
MIN MAX MIDDLE FALSE FALSE FALSE 1.36790 1.34740 1.34920 FALSE FALSE FALSE
And the following is the table that i would like to set up with the columns being the MIN and the rows being the MAX.
0.00100 0.00500 0.01000 0.00100 0.00500 0.01000
This is a multi part question and for the terms of simplicity I will only ask one for know. My question is this. Starting with the first column and MIN of 0.00100. I want to find a formula where if the Middle minus the MIN is large than the respective column in the table (in this instance 0.00100) than the MIN is automatically returned otherwise the middle is returned. In full this question will go down the entire length of the original columns. What i want to do is add the sum of all of the mins that are returned along with the middles that are returned. In only that first empty cell of the table. I plan on repeating this process for all of the other cells of the table as well. If you have any questions regarding this process please ask and I will try to further explain my issue to help you better understand it.