Spreadsheet: 717315d1612570298-sumif-vlookup-combo-billing-test-help
Sheet: 1

EE ID | EE Name | SubscriberId | EE ID | Status | Term Date
61 |  | 905229044 | 61 | A
1000 |  | 901513306 | 1000 | A
1001 |  | 901517829 | 1001 | A
1003 |  | 901503004 | 1003 | A
1007 |  | 902897184 | 1007 | A
1009 |  | 901511997 | 1009 | A
1011 |  | 905795788 | 1011 | A
1014 |  | 901446090 | 1014 | A
1033 |  | 901461138 | 1033 | A
1045 |  | 901492270 | 1045 | A
1046 |  | 901597576 | 1046 | A
1051 |  | 901483497 | 1051 | A
1069 |  | 901533632 | 1069 | A
1070 |  | 901509439 | 1070 | A
1073 |  | 901490627 | 1073 | A
1083 |  | 901453594 | 1083 | A
1110 |  | 901447931 | 1110 | A
1115 |  | 901461177 | 1115 | A
1121 |  | 902873004 | 1121 | A
1122 |  | 901459380 | 1122 | A
1132 |  | 901460733 | 1132 | A
1147 |  | 901446172 | 1147 | A
1170 |  | 901592827 | 1170 | A
1178 |  | 901460600 | 1178 | A
1179 |  | 901459545 | 1179 | A
1191 |  | 901473398 | 1191 | A
1206 |  | 901460354 | 1206 | A
1216 |  | 901461302 | 1216 | A
1228 |  | 901460242 | 1228 | A
1247 |  | 901447068 | 1247 | A
1269 |  | 901460311 | 1269 | A
1293 |  | 901461075 | 1293 | A
1303 |  | 901461219 | 1303 | A
1307 |  | 901459862 | 1307 | A
1310 |  | 901594211 | 1310 | A
1313 |  | 901460387 | 1313 | A
1317 |  | 905257730 | 1317 | A
1347 |  | 901517030 | 1347 | A
1348 |  | 901539886 | 1348 | A
1349 |  | 901499094 | 1349 | A
1350 |  | 901920803 | 1350 | A
1360 |  | 901560455 | 1360 | A
1373 |  | 901543177 | 1373 | A
1386 |  | 901570695 | 1386 | A
1436 |  | 901589960 | 1436 | A
1450 |  | 909613693 | 1450 | A
1452 |  | 902648461 | 1452 | A
1487 |  | 904922258 | 1487 | A
1496 |  | 902871635 | 1496 | A
1501 |  | 908999834 | 1501 | A
1516 |  | 903485683 | 1516 | A
1534 |  | 904167493 | 1534 | A
1545 |  | 904683271 | 1545 | A
1563 |  | 904919167 | 1563 | A
1570 |  | 905079434 | 1570 | A
1577 |  | 905229041 | 1577 | A
1580 |  | 905235351 | 1580 | A
1584 |  | 905229031 | 1584 | T | 2019-11-01 00:00:00
1597 |  | 905316643 | 1597 | A
1611 |  | 905389413 | 1611 | A
1613 |  | 905387743 | 1613 | A
1615 |  | 905406736 | 1615 | A
1637 |  | 905649602 | 1637 | A
1649 |  | 905788335 | 1649 | A
1650 |  | 905799811 | 1650 | A
1677 |  | 905893530 | 1677 | A
1682 |  | 905897315 | 1682 | A
1695 |  | 901505484 | 1695 | A
1705 |  | 905967458 | 1705 | A
1716 |  | 905973659 | 1716 | A
1726 |  | 905966273 | 1726 | T | 2020-11-20 00:00:00
1727 |  | 905965664 | 1727 | T | 2020-11-30 00:00:00
1737 |  | 906042470 | 1737 | T | 2020-12-18 00:00:00
1738 |  | 906054636 | 1738 | A
1748 |  | 906355013 | 1748 | A
1751 |  | 906344204 | 1751 | A
1754 |  | 906423824 | 1754 | A
1756 |  | 906421959 | 1756 | A
1757 |  | 906421965 | 1757 | A
1758 |  | 906421962 | 1758 | A
1759 |  | 906457223 | 1759 | A
1762 |  | 906457231 | 1762 | T | 2020-10-06 00:00:00
1768 |  | 906527964 | 1768 | A
1770 |  | 906514427 | 1770 | A
1772 |  | 906530220 | 1772 | A
1774 |  | 906560876 | 1774 | T | 2019-11-01 00:00:00
1780 |  | 906598547 | 1780 | A
1788 |  | 906669049 | 1788 | A
1789 |  | 906991966 | 1789 | A
1791 |  | 906972405 | 1791 | A
1792 |  | 906977876 | 1792 | A
1794 |  | 906970463 | 1794 | A
1795 |  | 906970048 | 1795 | A
1798 |  | 906970028 | 1798 | A
1800 |  | 906977834 | 1800 | A
1804 |  | 906970057 | 1804 | A
1806 |  | 909056234 | 1806 | A
1808 |  | 908879390 | 1808 | A
1811 |  | 909001533 | 1811 | A
1812 |  | 909001537 | 1812 | A
1813 |  | 909065332 | 1813 | A
1815 |  | 909065311 | 1815 | A
1817 |  | 909063292 | 1817 | A
1818 |  | 909063394 | 1818 | A
1824 |  | 909124070 | 1824 | A
1825 |  | 909155795 | 1825 | A
1829 |  | 909153856 | 1829 | A
1832 |  | 909194303 | 1832 | A
1834 |  | 909155756 | 1834 | A
1835 |  | 909251380 | 1835 | T | 2020-07-20 00:00:00
1838 |  | 909279945 | 1838 | A
1841 |  | 909397195 | 1841 | T | 2020-09-04 00:00:00
1843 |  | 909396890 | 1843 | A
1844 |  | 909392005 | 1844 | A
1845 |  | 909397194 | 1845 | A
1846 |  | 909396976 | 1846 | A
1847 |  | 909391947 | 1847 | A
1850 |  | 909392001 | 1850 | A
1854 |  | 901594196 | 1854 | A
1855 |  | 901520767 | 1855 | A
1856 |  | 906527962 | 1856 | A
1857 |  | 905322001 | 1857 | A
1859 |  | 905973647 | 1859 | A
1860 |  | 905862697 | 1860 | A
1863 |  | 909859933 | 1863 | A
1865 |  | 909859962 | 1865 | A
1866 |  | 909859964 | 1866 | A
1867 |  | 909859963 | 1867 | A
1870 |  | 909859807 | 1870 | A
1871 |  | 909859837 | 1871 | A
1874 |  | 909859821 | 1874 | A
1875 |  | 909859961 | 1875 | A
1876 |  | 909859960 | 1876 | A
1877 |  | 909859820 | 1877 | A
1879 |  | 909859842 | 1879 | A
1880 |  | 909859959 | 1880 | A
1882 |  | 909859951 | 1882 | A
1883 |  | 909859846 | 1883 | A
1885 |  | 909859847 | 1885 | A
1886 |  | 909859845 | 1886 | A
1887 |  | 909859844 | 1887 | A
1888 |  | 909859880 | 1888 | A
1889 |  | 909866082 | 1889 | A
1891 |  | 909859843 | 1891 | A
1893 |  | 909859810 | 1893 | A
1894 |  | 909859819 | 1894 | A
1896 |  | 909978174 | 1896 | A
1900 |  | 910019215 | 1900 | A
1901 |  | 910064611 | 1901 | A
1902 |  | 910115950 | 1902 | A
1904 |  | 910189021 | 1904 | A
1905 |  | 910166910 | 1905 | A