Spreadsheet: 69838d1270511168-need-alternative-to-sumproduct-slowing-down-spreadsheet-samplebook1
Sheet: Sheet1

Company A | Total Daily Revenue | Owner 1 | Owner 1 | Owner 2 | Owner 2 | Owner 3 | Owner 3
ACCT ID: |  | 1 | 1EM | 2 | 2EM | 3 | 3EM
Rev Share: |  | 0.5 | 0.5 | 0.4 | 0.4 | 0.6 | 0.6
2010-01-15 00:00:00 |  | 2.95 | 7.25 | 0 | 0 | 0 | 0
2010-01-16 00:00:00 |  | 0 | 10.15 | 0 | 0 | 0 | 2.9
2010-01-17 00:00:00 |  | 1.45 | 11.6 | 0 | 0 | 0 | 0
2010-01-18 00:00:00 |  | 1.45 | 7.25 | 5.8 | 0 | 0 | 0
2010-01-19 00:00:00 |  | 0 | 0 | 1.45 | 0 | 0 | 0
2010-01-20 00:00:00 |  | 1.45 | 0 | 4.35 | 0 | 0 | 0
2010-01-21 00:00:00 |  | 0 | 0 | 1.45 | 0 | 0 | 0
2010-01-22 00:00:00 |  | 5.8 | 0 | 13.05 | 1.45 | 0 | 0
2010-01-23 00:00:00 |  | 2.95 | 8.7 | 0 | 0 | 0 | 0
2010-01-24 00:00:00 |  | 2.9 | 17.4 | 0 | 0 | 0 | 0
2010-01-25 00:00:00 |  | 4.35 | 8.7 | 0 | 0 | 0 | 1.45
2010-01-26 00:00:00 |  | 0 | 1.45 | 0 | 0 | 0 | 0
2010-01-27 00:00:00 |  | 7.25 | 14.5 | 0 | 0 | 0 | 0
2010-01-28 00:00:00 |  | 1.45 | 5.8 | 0 | 0 | 0 | 0
2010-01-29 00:00:00 |  | 4.35 | 1.45 | 0 | 0 | 11.6 | 0
2010-01-30 00:00:00 |  | 0 | 4.35 | 0 | 0 | 8.7 | 0 |  | Sum of Revenue | Owner ID
2010-01-31 00:00:00 |  | 2.9 | 1.45 | 0 | 8.7 | 13.05 | 0 |  | Date | 1 | 2 | 3 | 1EM | 2EM | 3EM | Grand Total
2010-02-01 00:00:00 |  |  |  |  |  |  |  |  | 2010-02-01 00:00:00 | 5.8 |  | 4.35 | 13.05 | 4.35 |  | 27.55
2010-02-02 00:00:00 |  |  |  |  |  |  |  |  | 2010-02-02 00:00:00 | 7.25 |  | 10.15 | 2.9 | 10.15 |  | 30.45
2010-02-03 00:00:00 |  |  |  |  |  |  |  |  | 2010-02-03 00:00:00 | 2.95 |  |  | 7.25 | 1.45 |  | 11.65
2010-02-04 00:00:00 |  |  |  |  |  |  |  |  | 2010-02-04 00:00:00 | 4.35 |  |  |  | 13.05 | 1.45 | 18.85
2010-02-05 00:00:00 |  |  |  |  |  |  |  |  | 2010-02-05 00:00:00 | 5.8 |  |  | 10.15 |  |  | 15.95
2010-02-06 00:00:00 |  |  |  |  |  |  |  |  | 2010-02-06 00:00:00 |  |  |  | 5.8 |  |  | 5.8
2010-02-07 00:00:00 |  |  |  |  |  |  |  |  | 2010-02-07 00:00:00 | 5.8 |  |  | 5.8 |  |  | 11.6
2010-02-08 00:00:00 |  |  |  |  |  |  |  |  | 2010-02-08 00:00:00 | 7.25 |  |  | 1.45 |  |  | 8.7
2010-02-09 00:00:00 |  |  |  |  |  |  |  |  | 2010-02-09 00:00:00 | 1.45 |  |  | 8.7 |  |  | 10.15
2010-02-10 00:00:00 |  |  |  |  |  |  |  |  | 2010-02-10 00:00:00 | 1.45 | 1.45 |  | 4.35 |  |  | 7.25
2010-02-11 00:00:00 |  |  |  |  |  |  |  |  | 2010-02-11 00:00:00 | 4.35 | 4.35 |  | 10.15 |  |  | 18.85
2010-02-12 00:00:00 |  |  |  |  |  |  |  |  | 2010-02-12 00:00:00 |  | 1.45 |  | 1.45 |  |  | 2.9
2010-02-13 00:00:00 |  |  |  |  |  |  |  |  | 2010-02-13 00:00:00 | 4.35 |  |  | 13.05 |  |  | 17.4
2010-02-14 00:00:00 |  |  |  |  |  |  |  |  | 2010-02-14 00:00:00 | 7.25 |  |  | 2.9 |  |  | 10.15
2010-02-15 00:00:00 |  |  |  |  |  |  |  |  | 2010-02-15 00:00:00 | 10.15 |  |  | 4.35 |  | 11.6 | 26.1
 |  |  |  |  |  |  |  |  | Grand Total | 68.2 | 7.25 | 14.5 | 91.35 | 29 | 13.05 | 223.35
Company A Revenue
 | TOTAL
Date | Owner ID | Revenue | key
2010-02-01 00:00:00 | 2EM | 4.35
2010-02-01 00:00:00 | 3 | 4.35
2010-02-01 00:00:00 | 1 | 5.8
2010-02-01 00:00:00 | 1EM | 13.05
2010-02-02 00:00:00 | 1EM | 2.9
2010-02-02 00:00:00 | 1 | 7.25
2010-02-02 00:00:00 | 2EM | 10.15
2010-02-02 00:00:00 | 3 | 10.15
2010-02-03 00:00:00 | 2EM | 1.45
2010-02-03 00:00:00 | 1 | 2.95
2010-02-03 00:00:00 | 1EM | 7.25
2010-02-04 00:00:00 | 3EM | 1.45
2010-02-04 00:00:00 | 1 | 4.35
2010-02-04 00:00:00 | 2EM | 13.05
2010-02-05 00:00:00 | 1 | 5.8
2010-02-05 00:00:00 | 1EM | 10.15
2010-02-06 00:00:00 | 1EM | 5.8
2010-02-07 00:00:00 | 1 | 5.8
2010-02-07 00:00:00 | 1EM | 5.8
2010-02-08 00:00:00 | 1EM | 1.45
2010-02-08 00:00:00 | 1 | 7.25
2010-02-09 00:00:00 | 1 | 1.45
2010-02-09 00:00:00 | 1EM | 8.7
2010-02-10 00:00:00 | 1 | 1.45
2010-02-10 00:00:00 | 2 | 1.45
2010-02-10 00:00:00 | 1EM | 4.35
2010-02-11 00:00:00 | 1 | 4.35
2010-02-11 00:00:00 | 2 | 4.35
2010-02-11 00:00:00 | 1EM | 10.15
2010-02-12 00:00:00 | 1EM | 1.45
2010-02-12 00:00:00 | 2 | 1.45
2010-02-13 00:00:00 | 1 | 4.35
2010-02-13 00:00:00 | 1EM | 13.05
2010-02-14 00:00:00 | 1EM | 2.9
2010-02-14 00:00:00 | 1 | 7.25
2010-02-15 00:00:00 | 1EM | 4.35
2010-02-15 00:00:00 | 1 | 10.15
2010-02-15 00:00:00 | 3EM | 11.6