Spreadsheet: 66347d1267020405-finding-sums-using-conditionally-formatted-cells-ratesheet
Sheet: Sheet1

 |  | 0.00359752869725039 | 0.005310810094282207 | 0.008174418423651146 | 0.01163485780388805 | 0.01533394573739317 | 0.01889703184445673 | 0.02239036671277719 | 0.02522175927886485 | 0.03465235895464058 | 0.0412352128508186 | 0.0450924018688347 | 0.04790608495604896 | 0.04904326868482524 | 0.05048946507340706 | 0.05169709816928172 | 0.05260424976398477 | 0.05403901144341639 | 0.04928085764263473
 | 0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1.75 | -0.5 | -38.35 | -334.84 | -1318.48 | -2479.78 | -3821.27 | -5246.85 | -15488.41 | -20880.16 | -1411.32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2 | 0.46 | 39.53 | 361.49 | 1528.82 | 3057.07 | 4918.94 | 6986 | 21523.01 | 30090.03 | 2065.16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2.25 | 0 | 0 | 3.72 | 2.32 | 71.41 | 45.91 | 168.8 | 449.94 | 926.36 | 934.95 | 176.43 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2.5 | 0 | 0 | 4.73 | -22.98 | -49.23 | -205.52 | -161.57 | 227.84 | 1179.01 | 1189.93 | 224.55 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2.75 | 0 | 25.64 | 241.98 | 638.68 | 533.01 | 764.38 | 1362.15 | 27253.48 | 25955.46 | -2221.18 | -206.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 3 | -1.88 | -18.78 | -109.53 | -353.65 | -848.56 | -701.01 | -108.36 | 4739.32 | 2137.16 | -1628.76 | -310.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 3.25 | 0 | 4.36 | 51.71 | 218.3 | 535.44 | 542.74 | 1568.83 | -2258.14 | -21469.38 | -4073.68 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 3.5 | 0 | -10.43 | -150.47 | -782.77 | -2154.67 | -4447.94 | -6715.58 | -34500.82 | -67678.62 | -32678.82 | -11174.54 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 3.75 | 0.03 | 7.59 | 40.37 | 43.55 | 293.73 | 255.22 | -102.92 | 279.86 | 383.93 | 314.86 | -37.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 4 | 0.02 | 9.93 | 28.19 | -72.86 | 293.35 | 716.09 | 3592.75 | 12563.2 | 34375.27 | 7722.38 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 4.25 | -0.01 | -1.12 | -14.07 | -72.91 | -219.69 | -450.85 | -762.46 | -2732.93 | -1014.44 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 4.5 | -0.02 | -2.83 | -38.71 | -188.45 | -593.05 | -1325.5 | -2147.26 | -10682.01 | -50705.05 | -35972.18 | -5407.31 | -4592.1 | -3424.92 | -2137.81 | -539.44 | 0 | 0 | 0
 | 4.75 | 0 | 9.07 | 89.35 | 514.37 | 1508.32 | 3357.87 | 5608.17 | 21423.25 | 29963.85 | -3770.47 | -8110.97 | -6888.16 | -5137.39 | -3206.71 | -809.16 | 0 | 0 | 0
 | 5 | -0.27 | -8.8 | -112.64 | -557.82 | -1660.25 | -3158.52 | -4317.05 | -25554.99 | -33039 | -55745.41 | -48298.29 | -5396.73 | 184.88 | 0 | 0 | 0 | 0 | 0
 | 5.5 | 0.47 | 4.44 | 28.16 | 103.7 | -16.3 | -2527.39 | -1876.18 | -7349.45 | -11103.22 | 7991.45 | -2087.52 | -27036.9 | -33638.15 | -7979.19 | 3971.6 | 2905.35 | 173.26 | 0
 | 6 | -0.03 | -2.16 | -21.75 | -52.37 | -49.32 | 574.88 | 1501.77 | 7719.74 | 14119.45 | 7822.73 | 5590.06 | 7878.3 | 1367.68 | 1554.42 | -284.13 | -2984.78 | -177.96 | 0
 | 6.5 | -0.14 | -7.83 | -81.35 | -402.33 | -1674.95 | -2379.53 | -5991.61 | -10057.62 | -5534.68 | 44987.81 | 47167.35 | 33781.25 | 52707.75 | 27932.42 | 8826.84 | 0 | 0 | 0
 | 7 | -0.07 | -1.46 | -11.35 | -11.06 | -102.07 | 52.99 | -308.29 | 1456.35 | 12980.68 | -3875.92 | -11820.72 | -17951.62 | -5833.84 | -3477.14 | -2929.52 | -2161.74 | -128.65 | 0
 | 8 | -0.02 | -2.47 | -29.94 | -186.77 | -554.41 | -834.69 | -1688.55 | -7561.06 | -11526.05 | -9726.2 | -17569.11 | -18500.04 | -17831.48 | -15647.52 | -13080.04 | -9633.87 | -573.9 | 0
 | 9 | 0 | 0.83 | 6.95 | 37.17 | 149.37 | 383.89 | 779.7 | 4433.26 | 13605.48 | 18574.31 | 6689.24 | -12250.62 | -16513.29 | -20189.54 | -24322.27 | -13470.87 | 603.74 | 0
 | 10 | 0 | 0.1 | 1.64 | 15.04 | 62.88 | 164.76 | 377.92 | 2829.95 | 12990.03 | 47612.5 | 16997.57 | -26722.35 | -30964.06 | -32683.02 | -34291.46 | -21185.37 | 31.78 | 0