Spreadsheet: 744025d1628869553-countifs-with-index-match-mameri1-test
Sheet: Test

Quantity Table | Date
END_USER_CUSTOMER_NAME | 2020-08-15 00:00:00 | 2020-08-22 00:00:00 | 2020-08-29 00:00:00 | 2020-09-05 00:00:00 | 2020-09-12 00:00:00 | 2020-09-19 00:00:00 | 2020-09-26 00:00:00 | 2020-10-03 00:00:00 | 2020-10-10 00:00:00 | 2020-10-17 00:00:00 | 2020-10-24 00:00:00 | 2020-10-31 00:00:00 | 2020-11-07 00:00:00 | 2020-11-14 00:00:00 | 2020-11-21 00:00:00 | 2020-11-28 00:00:00 | 2020-12-05 00:00:00 | 2020-12-12 00:00:00 | 2020-12-19 00:00:00 | 2020-12-26 00:00:00 | 2021-01-02 00:00:00 | 2021-01-09 00:00:00 | 2021-01-16 00:00:00 | 2021-01-23 00:00:00 | 2021-01-30 00:00:00 | 2021-02-06 00:00:00 | 2021-02-13 00:00:00 | 2021-02-20 00:00:00 | 2021-02-27 00:00:00 | 2021-03-06 00:00:00 | 2021-03-13 00:00:00 | 2021-03-20 00:00:00 | 2021-03-27 00:00:00 | 2021-04-03 00:00:00 | 2021-04-10 00:00:00 | 2021-04-17 00:00:00 | 2021-04-24 00:00:00 | 2021-05-01 00:00:00 | 2021-05-08 00:00:00 | 2021-05-15 00:00:00 | 2021-05-22 00:00:00 | 2021-05-29 00:00:00 | 2021-06-05 00:00:00 | 2021-06-12 00:00:00 | 2021-06-19 00:00:00 | 2021-06-26 00:00:00 | 2021-07-03 00:00:00 | 2021-07-10 00:00:00 | 2021-07-17 00:00:00 | 2021-07-24 00:00:00 | 2021-07-31 00:00:00 | 2021-08-07 00:00:00 | Grand Total
A | 58.31 | 596.1128830524731 | 2082.844542446933 | 3926.733805288713 | 4132.781462095961 | 3771.354191275982 | 1574.500696450233 | 1337.62757027142 | 1437.267337764286 | 1621.530233889295 | 1791.246110257805 | 1920.05732969458 | 1762.662800599041 | 2067.629811786237 | 3490.664737280493 | 4064.555311554123 | 4073.011533192152 | 4073.231143579478 | 4370.491252881297 | 4568.384095675523 | 4550.602101231903 | 4580.230217692319 | 4582.030090289432 | 4582.398813552748 | 4582.063781022219 | 7356.330130811923 | 7554.153501289208 | 7553.992034914973 | 7553.99020389075 | 7554.409532651182 | 6490.02140670558 | 5678.559413747834 | 5678.756474421933 | 5678.996111468526 | 5679.095296943972 | 5679.401805807501 | 5679.6014532817 | 7216.3476012374 | 9139.932692716702 | 11523.3643375659 | 12284.1001315466 | 13618.7002629377 | 13618.0188279624 | 13617.5443850318 | 13617.3530688653 | 13617.6558096587 | 13617.783985257 | 13617.408909089 | 11280.1634979719 | 8409.2063597854 | 8408.970069645 | 8408.565370092503 | 325730.7445281223
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 606.3326081935 | 1849.8947387737 | 1813.9465290269 | 1682.4801619469 | 22897.4790431203 | 209216.3292754392 | 224556.3399291991 | 247179.387215197 | 267358.8259466202 | 267153.8216715417 | 271218.050212479 | 1515532.887331537
C |  |  |  |  |  |  |  |  |  |  |  | 113.7995322684946 | 168.2456664516129 | 2927.905216910137 | 11573.2878193876 | 20721.25175844452 | 41902.04020168408 | 42369.20679392752 | 42700.22119854257 | 42692.6473174217 | 42696.56684668196 | 36606.99815406855 | 19869.6040901483 | 19519.05342954162 | 21215.67789551664 | 22603.28227483758 | 22732.12224824947 | 22593.22655996515 | 24317.87932352169 | 27050.72558335576 | 10903.26663193599 | 7498.750568352781 | 7498.783935153405 | 7499.02569068243 | 7498.785417020429 | 7498.784130806701 | 7498.7850531204 | 7499.140227754401 | 7499.059507774801 | 7593.162220570401 | 7666.860984282402 | 11552.2207785396 | 7374.512446029701 | 6520.7961959304 | 6520.7964539759 | 6520.7967554714 | 6520.797869215201 | 6520.7968832669 | 6520.7969227739 | 6520.796491280301 | 6520.7962277716 | 6520.796536249001 | 628142.049838883
D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.799978978410936 |  |  |  |  |  | 3020.312835154981 | 4175.2434714556 | 4175.2365437851 | 4175.2424516684 | 4175.2388657949 | 4175.2374640932 | 4175.238764798801 | 4175.238827654601 | 2778.640960403301 |  |  |  |  |  |  |  |  |  | 35028.43016378728
E |  | 0.0003006845221 | 643.3104811700391 | 1782.988251278179 | 1781.524367084651 | 1782.979279054332 | 2144.840316358966 | 3798.982943219088 | 3798.977706793673 | 3798.979153853776 | 3799.004871404639 | 3798.994637476057 | 3799.178744702525 | 3799.144399909646 | 3799.139765833032 | 3799.134871138296 | 3799.138442486853 | 3799.134625687952 | 3799.101679383611 | 3781.627639298395 | 3797.968424943519 | 3799.108454533036 | 3799.119957737412 | 3799.10322573885 | 3799.100593842322 | 3799.100719422191 | 3799.10095566426 | 3799.101068887832 | 3799.10283296284 | 3799.10001125639 | 3799.09913070499 | 3799.102248936062 | 3799.105469060046 | 3799.102346370914 | 3799.101688537824 | 3799.109584778668 | 3799.107376729227 | 3799.098620944612 | 3799.110580644147 | 3799.103062036495 | 3799.072462058477 | 3799.103788076949 | 3799.105558428002 | 3799.10242441293 | 3799.104629062075 | 1424.036852523232 | 0 |  |  |  |  |  | 153906.6545451128
F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5278.9033187685 | 2180.935864709999 |  |  |  | 2883.4116818546 | 0 |  |  | 2.7936996001 | 0 |  |  | 10346.0445649332
G |  |  |  |  |  |  |  |  |  |  |  |  |  | 49.36070041370968 | 168.2258064516129 | 168.2258064516129 | 168.2427914516129 | 168.2610314516129 | 169.2118375516129 | 168.2457264516129 | 166.2419941935484 | 168.2459664516129 | 168.2460264516129 | 168.2458464516129 | 168.2458464516129 | 168.2459664516129 | 168.2459664516129 | 168.2459664516129 | 168.2459664516129 | 168.2457264516129 | 168.2460864516129 | 168.2456064516129 | 168.2461464516129 | 168.2459064516129 | 168.2458464515968 | 168.2460864515 | 168.2459664515 | 168.2456664515 | 168.2461464515 | 168.2459664515 | 168.2456064515 | 168.2457264515 | 168.2430864515 | 168.2279664515 | 168.2463264515 | 168.2421264515 | 168.2373264515 | 168.2459664515 | 168.2458464515 | 168.2441664515 | 168.2366064515 | 168.2404464515 | 6441.589594414994
Dollar Table | Date
END_USER_CUSTOMER_NAME | 2020-08-15 00:00:00 | 2020-08-22 00:00:00 | 2020-08-29 00:00:00 | 2020-09-05 00:00:00 | 2020-09-12 00:00:00 | 2020-09-19 00:00:00 | 2020-09-26 00:00:00 | 2020-10-03 00:00:00 | 2020-10-10 00:00:00 | 2020-10-17 00:00:00 | 2020-10-24 00:00:00 | 2020-10-31 00:00:00 | 2020-11-07 00:00:00 | 2020-11-14 00:00:00 | 2020-11-21 00:00:00 | 2020-11-28 00:00:00 | 2020-12-05 00:00:00 | 2020-12-12 00:00:00 | 2020-12-19 00:00:00 | 2020-12-26 00:00:00 | 2021-01-02 00:00:00 | 2021-01-09 00:00:00 | 2021-01-16 00:00:00 | 2021-01-23 00:00:00 | 2021-01-30 00:00:00 | 2021-02-06 00:00:00 | 2021-02-13 00:00:00 | 2021-02-20 00:00:00 | 2021-02-27 00:00:00 | 2021-03-06 00:00:00 | 2021-03-13 00:00:00 | 2021-03-20 00:00:00 | 2021-03-27 00:00:00 | 2021-04-03 00:00:00 | 2021-04-10 00:00:00 | 2021-04-17 00:00:00 | 2021-04-24 00:00:00 | 2021-05-01 00:00:00 | 2021-05-08 00:00:00 | 2021-05-15 00:00:00 | 2021-05-22 00:00:00 | 2021-05-29 00:00:00 | 2021-06-05 00:00:00 | 2021-06-12 00:00:00 | 2021-06-19 00:00:00 | 2021-06-26 00:00:00 | 2021-07-03 00:00:00 | 2021-07-10 00:00:00 | 2021-07-17 00:00:00 | 2021-07-24 00:00:00 | 2021-07-31 00:00:00 | 2021-08-07 00:00:00 | Grand Total
A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 843 | 0 | 4553 | 0 | 0 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 533 | 50 | 50 | 50 | 0 | 80 | 80 | 80 | 80 | 0 | 0 | 0 | 0 | 0
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
C |  |  |  |  | 643 | 92 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 453 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 438 | 438 | 438 | 438 | 438 | 438 | 438 | 0 |  |  |  |  |  |  |  |  |  | 3066
E |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 555 | 555 | 5554 | 445 | 80 | 80 | 46 | 54 | 0 | 0 | 0 | 0 | 5 | 5 | 5 | 5 | 5 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0
F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0
G |  |  |  |  |  | 54 | 46 | 46 | 46 | 46 | 46 | 88 | 46 | 46 | 46 | 46 | 0 | 0 | 883 | 0 | 445 | 666 | 4433 | 455 | 0 | 0 | 4557 | 0 | 44444 | 0 | 0 | 645 | 645 | 645 | 645 | 645 | 645 | 645 | 645 | 645 | 700 | 645 | 663.333333333333 | 663.333333333333 | 663.333333333333 | 663.333333333333 | 663.333333333333 | 663.333333333333 | 663.333333333333 | 663.333333333333 | 663.333333333333 | 0 | 0
Questions | Defined |  |  |  | [NAME]
Return first date Customer had a quantity greater than 0 | First Trial Date
Return first date Customer had a dollar | First Convert to Pay Date
# of customers that had a quantity for any date | # of all current Trials per date |  |  |  |  | Note: This formula is correct but your Grand Total numbers are wrong.
# of customers that had first ever quantity by date | # of first start of trials per date |  |  |  |  | No idea what this means
# of customers with first greater than 0 from dollar table | # of Convert to Pay Trials Per Date |  |  |  |  | No idea what this means
Length of time from first Quantity greater than 0 to first Dollar greater than 0 by Date | Time it takes to make money |  |  |  |  | Not clear
# of months from first Quantity to first Dollar by Customer | Time it takes to make money per Customer |  |  |  |  | Not clear
# of months quantity has been running per Customer | # of Months has active trials running |  |  |  |  | Not clear
# of months dollar per Customer | # of Months has been making mone |  |  |  |  | Not clear