Spreadsheet: 100999d1299177662-sumproduct-formula-with-multiple-locations-of-data-4mulaexample
Sheet: ClientA

Admit Date | Client | Acct number | Balance | Approved Date
2008-07-09 00:00:00 |  | 98542 | 82627.28 | 2008-08-14 00:00:00
2010-11-27 00:00:00 |  | 98542 | 105936.95 | 2010-12-16 00:00:00
2008-08-04 00:00:00 |  | 98542 | 2205.4 | 2010-12-29 00:00:00
2009-09-04 00:00:00 |  | 98542 | 31674.4 | 2010-12-31 00:00:00
2009-09-05 00:00:00 |  | 98542 | 134.9 | 2011-01-04 00:00:00
2009-09-01 00:00:00 |  | 98542 | 0 | 2011-01-27 00:00:00
2009-09-02 00:00:00 |  | 98542 | 54622.62 | 2011-01-31 00:00:00
2009-09-01 00:00:00 |  | 98542 | 104420.04 | 2010-12-15 00:00:00
2009-08-31 00:00:00 |  | 98542 | 3764.55 | 2010-12-15 00:00:00
2009-07-26 00:00:00 |  | 98542 | 532.09 | 2010-12-16 00:00:00
2010-09-04 00:00:00 |  | 98542 | 2758.33 | 2010-12-16 00:00:00
2009-09-15 00:00:00 |  | 98542 | 0 | 2010-12-22 00:00:00
2009-09-19 00:00:00 |  | 98542 | 4140.75 | 2010-12-22 00:00:00
2009-08-24 00:00:00 |  | 98542 | 269.39 | 2010-12-22 00:00:00
2009-10-01 00:00:00 |  | 98542 | 1958.26 | 2010-12-30 00:00:00
2009-08-20 00:00:00 |  | 98542 | 3662.86 | 2010-12-31 00:00:00
2009-09-22 00:00:00 |  | 98542 | 5539.86 | 2011-01-13 00:00:00
2009-09-14 00:00:00 |  | 98542 | 1412.57 | 2011-02-22 00:00:00
2009-09-22 00:00:00 |  | 98542 | 9822.07 | 2011-02-22 00:00:00
2009-09-06 00:00:00 |  | 98542 | 2758.57 | 2011-02-24 00:00:00
2009-09-26 00:00:00 |  | 98542 | 2113.49 | 2010-12-10 00:00:00
2008-12-11 00:00:00 |  | 98542 | 1711.87 | 2009-12-01 00:00:00
2008-11-03 00:00:00 |  | 98542 | 4229.99 | 2009-11-15 00:00:00
2009-09-10 00:00:00 |  | 98542 | 660.8 | 2009-10-30 00:00:00
2009-05-26 00:00:00 |  | 98542 | 0 | 2010-01-23 00:00:00
2009-06-30 00:00:00 |  | 98542 | 6286.53 | 2009-12-23 00:00:00
2009-09-03 00:00:00 |  | 98542 | 0 | 2010-01-08 00:00:00
2009-07-17 00:00:00 |  | 98542 | 54546.29 | 2009-10-31 00:00:00
2009-06-25 00:00:00 |  | 98542 | 51521.4 | 2010-01-20 00:00:00
2009-08-14 00:00:00 |  | 98542 | 1876.92 | 2009-10-30 00:00:00
2009-06-01 00:00:00 |  | 98542 | 532.09 | 2009-12-01 00:00:00
2009-03-04 00:00:00 |  | 98542 | 532.09 | 2010-01-28 00:00:00
2009-02-13 00:00:00 |  | 98542 | 532.09 | 2009-11-06 00:00:00
2009-10-01 00:00:00 |  | 98542 | 678.1 | 2010-01-27 00:00:00
2009-07-23 00:00:00 |  | 98542 | 82560.29 | 2009-10-22 00:00:00
2009-09-25 00:00:00 |  | 98542 | 0 | 2010-03-19 00:00:00
2009-08-08 00:00:00 |  | 98542 | 89758.73 | 2010-05-07 00:00:00
2009-08-06 00:00:00 |  | 98542 | 29617.14 | 2010-01-20 00:00:00
2009-08-04 00:00:00 |  | 98542 | 2715.83 | 2010-02-23 00:00:00
2009-08-22 00:00:00 |  | 98542 | 0 | 2009-11-30 00:00:00
2009-08-25 00:00:00 |  | 98542 | 0 | 2010-01-27 00:00:00
2009-08-26 00:00:00 |  | 98542 | 3289.2 | 2010-01-28 00:00:00
2009-08-26 00:00:00 |  | 98542 | 0 | 2010-01-22 00:00:00
2009-08-30 00:00:00 |  | 98542 | 1893.1 | 2010-02-19 00:00:00
2009-09-19 00:00:00 |  | 98542 | 0 | 2009-11-15 00:00:00
2009-09-18 00:00:00 |  | 98542 | 0 | 2010-01-08 00:00:00
2009-09-18 00:00:00 |  | 98542 | 0 | 2010-01-20 00:00:00
2009-09-20 00:00:00 |  | 98542 | 2114.44 | 2010-01-08 00:00:00
2009-09-22 00:00:00 |  | 98542 | 0 | 2009-10-08 00:00:00
2009-09-21 00:00:00 |  | 98542 | 0 | 2009-10-08 00:00:00
2009-09-17 00:00:00 |  | 98542 | 146431.64 | 2009-10-08 00:00:00
2009-09-27 00:00:00 |  | 98542 | 1176.14 | 2009-10-08 00:00:00
2009-09-24 00:00:00 |  | 98542 | 1240.83 | 2009-10-08 00:00:00
2009-09-01 00:00:00 |  | 98542 | 0 | 2009-10-08 00:00:00
2009-09-03 00:00:00 |  | 98542 | 0 | 2009-10-08 00:00:00
2010-10-28 00:00:00 |  | 98542 | 0 | 2009-10-08 00:00:00
2009-09-01 00:00:00 |  | 98542 | 0 | 2009-10-08 00:00:00
2009-09-23 00:00:00 |  | 98542 | 5492.85 | 2009-10-08 00:00:00
2009-08-30 00:00:00 |  | 98542 | 59297.8 | 2009-10-08 00:00:00
2009-09-06 00:00:00 |  | 98542 | 1754.91 | 2009-10-09 00:00:00
2009-09-05 00:00:00 |  | 98542 | 71405.63 | 2009-10-09 00:00:00
2009-09-21 00:00:00 |  | 98542 | 678.1 | 2009-10-09 00:00:00
2009-09-21 00:00:00 |  | 98542 | 269.39 | 2009-10-09 00:00:00
2009-08-07 00:00:00 |  | 98542 | 532.09 | 2009-10-09 00:00:00
2009-09-10 00:00:00 |  | 98542 | 2080.21 | 2009-10-09 00:00:00
2009-08-13 00:00:00 |  | 98542 | 1434.69 | 2009-10-09 00:00:00
2010-12-16 00:00:00 |  | 98542 | 1270.3 | 2009-10-09 00:00:00
2010-12-29 00:00:00 |  | 98542 | 1975.16 | 2009-10-09 00:00:00
2010-12-31 00:00:00 |  | 98542 | 1270.3 | 2010-12-05 00:00:00
2011-01-04 00:00:00 |  | 98542 | 1924.54 | 2009-10-09 00:00:00
2011-01-27 00:00:00 |  | 98542 | 10195.7 | 2009-10-09 00:00:00
2011-01-31 00:00:00 |  | 98542 | 27359.03 | 2009-10-12 00:00:00
2010-12-15 00:00:00 |  | 98542 | 36530.73 | 2009-10-02 00:00:00
2010-12-15 00:00:00 |  | 98542 | 28142.79 | 2009-10-12 00:00:00
2010-12-16 00:00:00 |  | 98542 | 1152.93 | 2009-10-12 00:00:00
2010-12-16 00:00:00 |  | 98542 | 1183.51 | 2009-10-12 00:00:00
2010-12-22 00:00:00 |  | 98542 | 1609.37 | 2009-10-12 00:00:00
2010-12-22 00:00:00 |  | 98542 | 1561.38 | 2010-10-12 00:00:00
2010-12-22 00:00:00 |  | 98542 | 802.37 | 2009-10-12 00:00:00
2010-12-30 00:00:00 |  | 98542 | 12588.85 | 2009-10-13 00:00:00
2010-12-31 00:00:00 |  | 98542 | 944.83 | 2009-10-13 00:00:00
2011-01-13 00:00:00 |  | 98542 | 900.35 | 2009-10-13 00:00:00
2011-02-22 00:00:00 |  | 98542 | 1659.11 | 2009-10-13 00:00:00
2011-02-22 00:00:00 |  | 98542 | 1092.94 | 2009-10-13 00:00:00
2011-02-24 00:00:00 |  | 98542 | 1398.96 | 2009-10-12 00:00:00
2010-12-10 00:00:00 |  | 98542 | 943.71 | 2009-10-13 00:00:00
2009-01-16 00:00:00 |  | 98542 | 532.09 | 2009-10-12 00:00:00
2009-09-23 00:00:00 |  | 98542 | 532.09 | 2011-01-10 00:00:00
2009-10-03 00:00:00 |  | 98542 | 532.09 | 2009-10-13 00:00:00
2009-10-04 00:00:00 |  | 98542 | 3677.16 | 2009-10-13 00:00:00
2009-09-24 00:00:00 |  | 98542 | 532.09 | 2009-10-13 00:00:00
2009-10-01 00:00:00 |  | 98542 | 5377.7 | 2009-10-13 00:00:00
2009-09-29 00:00:00 |  | 98542 | 821.39 | 2009-10-13 00:00:00
2009-10-02 00:00:00 |  | 98542 | 532.09 | 2009-10-13 00:00:00
2009-10-08 00:00:00 |  | 98542 | 1380.6 | 2009-10-13 00:00:00
2009-09-23 00:00:00 |  | 98542 | 532.09 | 2009-10-13 00:00:00
2009-09-28 00:00:00 |  | 98542 | 27888.77 | 2009-10-07 00:00:00
2010-04-19 00:00:00 |  | 98542 | 29139.02 | 2011-10-14 00:00:00
2009-07-02 00:00:00 |  | 98542 | 20475.75 | 2009-10-14 00:00:00
2009-08-17 00:00:00 |  | 98542 | 48061.61 | 2009-10-14 00:00:00
2009-10-02 00:00:00 |  | 98542 | 2611.55 | 2009-10-14 00:00:00
2009-10-07 00:00:00 |  | 98542 | 11058.53 | 2009-10-14 00:00:00
2009-07-09 00:00:00 |  | 98542 | 1163.25 | 2009-10-14 00:00:00
2009-05-07 00:00:00 |  | 98542 | 39096.97 | 2009-10-14 00:00:00
2009-09-02 00:00:00 |  | 98542 | 0 | 2009-10-14 00:00:00
2009-09-02 00:00:00 |  | 98542 | 31960.95 | 2009-10-14 00:00:00
2009-08-24 00:00:00 |  | 98542 | 3087.71 | 2009-10-15 00:00:00
2009-09-15 00:00:00 |  | 98542 | 0 | 2009-10-15 00:00:00
2009-09-30 00:00:00 |  | 98542 | 2709.81 | 2009-10-15 00:00:00
2009-09-22 00:00:00 |  | 98542 | 0 | 2009-10-15 00:00:00
2009-09-12 00:00:00 |  | 98542 | 1657.8 | 2009-10-15 00:00:00
2010-09-15 00:00:00 |  | 98542 | 29025.8 | 2010-10-15 00:00:00
2009-09-30 00:00:00 |  | 98542 | 50247.08 | 2009-10-15 00:00:00
2009-09-21 00:00:00 |  | 98542 | 15372.22 | 2009-10-15 00:00:00
2009-09-19 00:00:00 |  | 98542 | 962.64 | 2009-10-15 00:00:00
2009-09-19 00:00:00 |  | 98542 | 36330.64 | 2009-10-15 00:00:00
2009-09-22 00:00:00 |  | 98542 | 0 | 2009-09-22 00:00:00
2010-02-21 00:00:00 |  | 98542 | 36024.08 | 2009-09-17 00:00:00
2010-02-18 00:00:00 |  | 98542 | 40287.03 | 2009-10-15 00:00:00
2010-02-26 00:00:00 |  | 98542 | 0 | 2009-10-15 00:00:00
2009-03-13 00:00:00 |  | 98542 | 2780.99 | 2009-10-15 00:00:00
2009-10-23 00:00:00 |  | 98542 | 0 | 2009-10-15 00:00:00
2010-02-22 00:00:00 |  | 98542 | 0 | 2009-10-15 00:00:00
2010-02-19 00:00:00 |  | 98542 | 0 | 2009-10-15 00:00:00
2010-02-16 00:00:00 |  | 98542 | 32311.95 | 2009-10-15 00:00:00
2010-01-28 00:00:00 |  | 98542 | 5096.55 | 2009-10-15 00:00:00
2009-02-10 00:00:00 |  | 98542 | 0 | 2009-10-16 00:00:00
2009-12-14 00:00:00 |  | 98542 | 2642.13 | 2009-10-17 00:00:00
2010-01-28 00:00:00 |  | 98542 | 5298.59 | 2009-10-17 00:00:00
2009-12-07 00:00:00 |  | 98542 | 3478.82 | 2009-10-18 00:00:00
2010-01-03 00:00:00 |  | 98542 | 95849.02 | 2009-10-18 00:00:00
2010-01-21 00:00:00 |  | 98542 | 1795.26 | 2009-10-18 00:00:00
2010-01-23 00:00:00 |  | 98542 | 0 | 2009-10-18 00:00:00
2009-10-24 00:00:00 |  | 98542 | 1307.32 | 2009-10-18 00:00:00
2009-11-13 00:00:00 |  | 98542 | 0 | 2009-10-18 00:00:00
2009-11-14 00:00:00 |  | 98542 | 0 | 2009-10-18 00:00:00
2009-11-23 00:00:00 |  | 98542 | 0 | 2009-10-18 00:00:00
2010-02-02 00:00:00 |  | 98542 | 3027.03 | 2009-10-18 00:00:00
2010-02-20 00:00:00 |  | 98542 | 28458.13 | 2009-10-18 00:00:00
2010-02-18 00:00:00 |  | 98542 | 2612.06 | 2009-10-18 00:00:00
2010-02-19 00:00:00 |  | 98542 | 2133.84 | 2009-10-18 00:00:00
2010-01-29 00:00:00 |  | 98542 | 887.71 | 2009-10-18 00:00:00
2010-01-26 00:00:00 |  | 98542 | 1714.72 | 2009-10-18 00:00:00
2010-02-20 00:00:00 |  | 98542 | 0 | 2009-10-18 00:00:00
2010-02-02 00:00:00 |  | 98542 | 1945.04 | 2009-10-18 00:00:00
2009-04-14 00:00:00 |  | 98542 | 8711.01 | 2009-10-19 00:00:00
2010-01-28 00:00:00 |  | 98542 | 3097.5 | 2009-10-19 00:00:00
2009-07-21 00:00:00 |  | 98542 | 911.71 | 2009-10-19 00:00:00
2009-07-31 00:00:00 |  | 98542 | 84603.27 | 2009-10-19 00:00:00
2009-09-06 00:00:00 |  | 98542 | 0 | 2009-10-20 00:00:00
2009-09-07 00:00:00 |  | 98542 | 0 | 2009-10-20 00:00:00
2009-09-06 00:00:00 |  | 98542 | 0 | 2009-10-20 00:00:00
2009-08-10 00:00:00 |  | 98542 | 134.9 | 2009-10-21 00:00:00
2009-08-10 00:00:00 |  | 98542 | 3025.04 | 2009-10-21 00:00:00
2009-08-17 00:00:00 |  | 98542 | 11951.6 | 2009-10-21 00:00:00
2008-11-16 00:00:00 |  | 98542 | 29175.36 | 2011-02-16 00:00:00
2009-10-15 00:00:00 |  | 98542 | 5469.81 | 2010-11-22 00:00:00
2008-12-16 00:00:00 |  | 98542 | 26362.69 | 2010-11-22 00:00:00
2008-12-30 00:00:00 |  | 98542 | 532.09 | 2010-11-22 00:00:00
2009-09-09 00:00:00 |  | 98542 | 2524.28 | 2010-11-30 00:00:00
2009-10-12 00:00:00 |  | 98542 | 961.26 | 2010-11-30 00:00:00
2010-12-16 00:00:00 |  | 98542 | 3187.83 | 2010-11-30 00:00:00
2010-12-29 00:00:00 |  | 98542 | 96.53 | 2010-12-02 00:00:00
2010-12-31 00:00:00 |  | 98542 | 3840.48 | 2010-12-02 00:00:00
2011-01-04 00:00:00 |  | 98542 | 3744.52 | 2010-12-03 00:00:00
2011-01-27 00:00:00 |  | 98542 | 1515.04 | 2010-12-14 00:00:00
2011-01-31 00:00:00 |  | 98542 | 0 | 2010-12-14 00:00:00
2010-12-15 00:00:00 |  | 98542 | 0 | 2010-12-30 00:00:00
2010-12-15 00:00:00 |  | 98542 | 0 | 2010-12-31 00:00:00
2010-12-16 00:00:00 |  | 98542 | 2853.38 | 2011-01-18 00:00:00
2010-12-16 00:00:00 |  | 98542 | 0 | 2011-02-10 00:00:00
2010-12-22 00:00:00 |  | 98542 | 0 | 2011-02-28 00:00:00
2010-12-22 00:00:00 |  | 98542 | 1066.85 | 2011-02-28 00:00:00
2010-12-22 00:00:00 |  | 98542 | 25761.8 | 2010-11-23 00:00:00
2010-12-30 00:00:00 |  | 98542 | 0 | 2010-11-30 00:00:00
2010-12-31 00:00:00 |  | 98542 | 0 | 2010-11-30 00:00:00
2011-01-13 00:00:00 |  | 98542 | 0 | 2010-12-02 00:00:00
2011-02-22 00:00:00 |  | 98542 | 0 | 2010-12-02 00:00:00
2011-02-22 00:00:00 |  | 98542 | 0 | 2010-12-07 00:00:00
2011-02-24 00:00:00 |  | 98542 | 1960.69 | 2010-12-08 00:00:00
2010-12-10 00:00:00 |  | 98542 | 0 | 2010-12-08 00:00:00
2009-10-09 00:00:00 |  | 98542 | 0 | 2010-12-08 00:00:00
2009-09-10 00:00:00 |  | 98542 | 1124.23 | 2010-12-14 00:00:00
2009-10-01 00:00:00 |  | 98542 | 3120.66 | 2010-12-14 00:00:00
2009-10-07 00:00:00 |  | 98542 | 2206.31 | 2010-12-14 00:00:00
2009-10-22 00:00:00 |  | 98542 | 862.61 | 2010-12-21 00:00:00
2009-07-31 00:00:00 |  | 98542 | 51734.99 | 2010-12-24 00:00:00
2009-07-21 00:00:00 |  | 98542 | 2062.63 | 2010-12-31 00:00:00
2008-08-27 00:00:00 |  | 98542 | 3807.18 | 2011-01-18 00:00:00
2008-08-25 00:00:00 |  | 98542 | $10, 471.34 | 2011-02-02 00:00:00
2009-10-21 00:00:00 |  | 98542 | 282.5 | 2011-02-17 00:00:00
2009-07-04 00:00:00 |  | 98542 | 2076.45 | 2010-11-30 00:00:00