Spreadsheet: 69363d1269902417-sumif-with-indirect-sample-book
Sheet: Summary by Month

Summary by Month |  | JANUARY |  |  |  | FEBRUARY |  |  |  | ETC.
Company Name | Owner ID | Monthly Earnings Net of Expenses |  | Net Monthly Earned RevShare | Total Collected Revenue | Monthly Earnings Net of Expenses |  | Net Monthly Earned RevShare | Total Collected Revenue
Business 1 | 231 | 1.84 | 2.1 | 1.77 | 0.91 | 0 | 0 | 1.77 | 0.91
Business 2 | 67 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 3 | 204 | 79.9216546676 | 53.91 | 0 | 0 | 72.71 | 34.16 | 0 | 0
Business 4 | 200 | 21.19 | 0 | 0 | 0 | 17.01 | 0 | 0 | 0
Business 5 | 137 | 3.48403242895604 | 9.02 | 6.25 | 4.42 | 0.14 | 0 | 6.25 | 4.42
Business 6 | 194 | 0.6699999999999999 | 1.99 | 1.33 | 0.96 | 0 | 0 | 1.33 | 0.96
Business 7 | 246 | 1.509677625248241 | 2.91 | 2.21 | 1.49 | 1.15 | 0 | 2.21 | 1.49
Business 8 | 107 | 74.267112563576 | 12.12 | 10.19 | 67.87 | 65.94 | 10.07 | 10.19 | 67.87
Business 9 | 224 | 12.67015988264 | 19.41 | 15.04 | 10.9 | 12.86 | 17.47 | 15.04 | 10.9
Business 10 | 273 | 30.61780304897 | 47.4 | 38.01 | 26.86 | 38.41 | 52.49 | 38.01 | 26.86
Business 11 | 95 | 0 | 0 | 0 | 0 | 0.14 | 0 | 0 | 0
Business 12 | 96 | 1.34 | 2.52 | 1.93 | 1.22 | 2.11 | 0 | 1.93 | 1.22
Business 13 | 97 | 0 | 0 | 0 | 0 | 0.14 | 0 | 0 | 0
Business 14 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 15 | 154 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 16 | 174 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 17 | 193 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 18 | 191 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 19 | 188 | 0.6699999999999999 | 2.15 | 1.41 | 1.04 | 0.19 | 0.46 | 1.41 | 1.04
Business 20 | 192 | 0.6699999999999999 | 0.91 | 0.79 | 0.44 | 0 | 0 | 0.79 | 0.44
Business 21 | 185 | 0.6699999999999999 | 1.71 | 1.19 | 0.83 | 0 | 0 | 1.19 | 0.83
Business 22 | 190 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 23 | 232 | 23.474122445583 | 40.09 | 25.43 | 17.1 | 15.51 | 26.29 | 25.43 | 17.1
Business 24 | 176 | 106.6564289432208 | 150.67 | 12.66 | 81.67 | 222.17 | 243.89 | 128.66 | 81.67
Business 25 | 162 | 17.92353221354854 | 27.86 | 22.89 | 14.49 | 5.960000000000001 | 0.17 | 22.89 | 14.49
Business 26 | 120 | 34.87110396925 | 47.93 | 41.4 | 25.88 | 45.66 | 55.69 | 41.4 | 25.88
Business 27 | 114 | 1.34 | 3.44 | 2.39 | 1.66 | 3.85 | 0 | 2.39 | 1.66
Business 28 | 108 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 29 | 237 | 0.8930647940851257 | 1.5 | 1.2 | 0.84 | 1.18 | 0 | 1.2 | 0.84
Business 30 | 157 | 130.1780274559696 | 24.45 | 185.81 | 125.74 | 61.34 | 96.22 | 185.81 | 125.74
Business 31 | 304 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 32 | 243 | 72.737181989499 | 13.84 | 10.29 | 71.96 | 70.3 | 10.67 | 10.29 | 71.96
Business 33 | 12 | 1.34 | 3.22 | 2.28 | 1.55 | 0.14 | 0 | 2.28 | 1.55
Business 34 | 156 | 0.6699999999999999 | 0.91 | 0.79 | 0.44 | 0 | 0 | 0.79 | 0.44
Business 35 | 285 | 1.379677625248241 | 0 | 0.55 | 0.55 | 0 | 0 | 0.55 | 0.55
Business 36 | 235 | 27.55774248316033 | 23.77 | 20.53 | 16.03 | 5.640000000000001 | 1.42 | 20.53 | 16.03
Business 37 | 263 | 1.648064857912081 | 2.84 | 1.8 | 1.21 | 1.22 | 0 | 1.8 | 1.21
Business 38 | 116 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 39 | 207 | 3.09 | 1.44 | 2.27 | 1.91 | 0.22 | 0.19 | 2.27 | 1.91
Business 40 | 267 | 14.80523203537451 | 20.63 | 14.17 | 9.97 | 12.48 | 20.72 | 14.17 | 9.97
Business 41 | 31 | 14.71249117588 | 25.62 | 19.67 | 13.65 | 13.47 | 22.15 | 19.67 | 13.65
Business 42 | 215 | 11.12975389447 | 16.74 | 14.43 | 92.4 | 16.14 | 25.64 | 14.43 | 92.4
Business 43 | 5 | 23.79770827610663 | 26.08 | 24.94 | 18.33 | 11.45 | 2.31 | 24.94 | 18.33
Business 44 | 284 | 8.022743951180283 | 0.95 | 3.59 | 2.4 | 3.61 | 0 | 3.59 | 2.4
Business 45 | 40 | 39.07403242895604 | 83.43 | 61.25 | 40.29 | 1.39 | 0 | 61.25 | 40.29
Business 46 | 127 | 192.2311114784012 | 33.89 | 26.06 | 17.02 | 211.13 | 32.37 | 26.06 | 178.02
Business 47 | 128 | 20.378201180216 | 38.03 | 29.7 | 19.4 | 23.53 | 45.61 | 29.7 | 19.4
Business 48 | 129 | 48.379922465615 | 92.79 | 70.08 | 47.89 | 56.41 | 83.23 | 70.08 | 47.89
Business 49 | 119 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 50 | 139 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 51 | 140 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 52 | 141 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 53 | 142 | 0 | 0 | 0 | 0 | 1.18 | 0 | 0 | 0
Business 54 | 143 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 55 | 89 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 56 | 59 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Business 57 | 54 | 93.204381439711 | 13.78 | 11.49 | 74.98 | 65.18 | 94.86 | 11.49 | 74.98
Business 58 | 32 | 41.3928493717 | 72.15 | 57.27 | 38.73 | 36.58 | 59.49 | 57.27 | 38.73
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0