Spreadsheet: 745660d1630082920-sumproduct-addition-using-wildcards-book1
Sheet: Sheet1

 | 0866010.01 |  |  |  |  |  |  |  |  |  |  | 0866010.01.A |  |  |  |  |  |  |  |  |  |  | 0866010.01.B
 | Week Ending | Amount | Monthly Amount | Month | Cumulative Spend | % of Budget | % Complete | Earned Value | Planned | Planned Cumulative |  | Week Ending | Amount | Monthly Amount | Month | Cumulative Spend | % of Budget | % Complete | Earned Value | Planned | Planned Cumulative |  | Week Ending | Amount | Monthly Amount | Month | Cumulative Spend | % of Budget | % Complete | Earned Value | Planned | Planned Cumulative
 |  |  |  |  |  | 0.6213909614154765 | 0.4 | 0 |  |  |  |  |  |  |  | 145747.25 | 0.6213909614154765 | 0.4 | 0 |  | 130000 |  |  |  |  |  | 55805.92 | 0.4110516982626069 | 0.4 |  |  | 68000
 | 2020-12-18 00:00:00 |  |  |  | 0 | 0 |  |  |  |  |  | 2020-12-18 00:00:00 | 0 |  |  | 0 | 0 |  | #N/A |  |  |  | 2020-12-18 00:00:00 | 0 |  |  | 0 | 0
 | 2020-12-25 00:00:00 |  |  | 2020-12-01 00:00:00 |  | 0 |  |  |  |  |  | 2020-12-25 00:00:00 | 0 | 0 | 2020-12-01 00:00:00 | 0 | 0 |  | #N/A |  |  |  | 2020-12-25 00:00:00 | 0 | 0 | 2020-12-01 00:00:00 | 0 | 0
 | 2021-01-01 00:00:00 |  |  |  |  | 0 |  |  |  |  |  | 2021-01-01 00:00:00 | 0 |  |  | 0 | 0 |  | #N/A |  |  |  | 2021-01-01 00:00:00 | 0 |  |  | 0 | 0
 | 2021-01-08 00:00:00 |  |  |  |  | 0.01369643999147303 |  |  |  |  |  | 2021-01-08 00:00:00 | 3212.5 |  |  | 3212.5 | 0.01369643999147303 |  | #N/A |  |  |  | 2021-01-08 00:00:00 | 560 |  |  | 560 | 0.004124812403900158 |  |  | 5000
 | 2021-01-15 00:00:00 |  |  |  |  | 0.04379663184822 |  |  |  |  |  | 2021-01-15 00:00:00 | 7060 |  |  | 10272.5 | 0.04379663184822 |  | #N/A |  |  |  | 2021-01-15 00:00:00 | 1515 |  |  | 2075 | 0.01528390310373719
 | 2021-01-22 00:00:00 |  |  |  |  | 0.08248774248561075 |  |  |  |  |  | 2021-01-22 00:00:00 | 9075 |  |  | 19347.5 | 0.08248774248561075 |  | #N/A |  |  |  | 2021-01-22 00:00:00 | 2672.5 |  |  | 4747.5 | 0.03496883372770714
 | 2021-01-29 00:00:00 |  |  | 2021-01-01 00:00:00 |  | 0.1422937539970155 |  |  |  |  |  | 2021-01-29 00:00:00 | 14027.5 | 33375 | 2021-01-01 00:00:00 | 33375 | 0.1422937539970155 |  | #N/A | 40000 |  |  | 2021-01-29 00:00:00 | 21240 | 25987.5 | 2021-01-01 00:00:00 | 25987.5 | 0.1914170756184917 |  |  | 8000
 | 2021-02-05 00:00:00 |  |  |  |  | 0.1905403965039437 |  |  |  |  |  | 2021-02-05 00:00:00 | 11316.25 |  |  | 44691.25 | 0.1905403965039437 | 0.1 | #N/A |  |  |  | 2021-02-05 00:00:00 | 405 |  |  | 26392.5 | 0.1944001988748838 | 0.1
 | 2021-02-12 00:00:00 |  |  |  |  | 0.2427360903858452 |  |  |  |  |  | 2021-02-12 00:00:00 | 12242.5 |  |  | 56933.75 | 0.2427360903858452 |  | #N/A |  |  |  | 2021-02-12 00:00:00 | 877.5 |  |  | 27270 | 0.2008636325970666
 | 2021-02-19 00:00:00 |  |  |  |  | 0.2933916009379663 |  |  |  |  |  | 2021-02-19 00:00:00 | 11881.25 |  |  | 68815 | 0.2933916009379663 |  | #N/A |  |  |  | 2021-02-19 00:00:00 | 540 |  |  | 27810 | 0.204841130272256
 | 2021-02-26 00:00:00 |  |  | 2021-02-01 00:00:00 |  | 0.2554839053506715 |  |  |  |  |  | 2021-02-26 00:00:00 | -8891.25 | 26548.75 | 2021-02-01 00:00:00 | 59923.75 | 0.2554839053506715 | 0.2 | #N/A | 40000 |  |  | 2021-02-26 00:00:00 | 2025 | 3847.5 | 2021-02-01 00:00:00 | 29835 | 0.2197567465542164 | 0.2 |  | 20000
 | 2021-03-05 00:00:00 |  |  |  |  | 0.289591771477297 |  |  |  |  |  | 2021-03-05 00:00:00 | 8000 |  |  | 67923.75 | 0.289591771477297 |  | #N/A |  |  |  | 2021-03-05 00:00:00 | 0 |  |  | 29835 | 0.2197567465542164
 | 2021-03-12 00:00:00 |  |  |  |  | 0.3219409507567683 |  |  |  |  |  | 2021-03-12 00:00:00 | 7587.5 |  |  | 75511.25 | 0.3219409507567683 |  | #N/A |  |  |  | 2021-03-12 00:00:00 | 180 |  |  | 30015 | 0.2210825791126129
 | 2021-03-19 00:00:00 |  |  |  |  | 0.3427680665103389 |  |  |  |  |  | 2021-03-19 00:00:00 | 4885 |  |  | 80396.25 | 0.3427680665103389 | 0.3 | #N/A |  |  |  | 2021-03-19 00:00:00 | 0 |  |  | 30015 | 0.2210825791126129 | 0.3
 | 2021-03-26 00:00:00 |  |  | 2021-03-01 00:00:00 |  | 0.2913611170326156 |  |  |  |  |  | 2021-03-26 00:00:00 | -12057.5 | 8415 | 2021-03-01 00:00:00 | 68338.75 | 0.2913611170326156 |  | #N/A | 40000 |  |  | 2021-03-26 00:00:00 | 0 | 180 | 2021-03-01 00:00:00 | 30015 | 0.2210825791126129 |  |  | 20000
 | 2021-04-02 00:00:00 |  |  |  |  | 0.304428693242379 |  |  |  |  |  | 2021-04-02 00:00:00 | 3065 |  |  | 71403.75 | 0.304428693242379 |  | #N/A |  |  |  | 2021-04-02 00:00:00 | 360 |  |  | 30375 | 0.2237342442294059
 | 2021-04-09 00:00:00 |  |  |  |  | 0.3205126838627159 |  |  |  |  |  | 2021-04-09 00:00:00 | 3772.5 |  |  | 75176.25 | 0.3205126838627159 |  | #N/A | 5000 |  |  | 2021-04-09 00:00:00 | 495 |  |  | 30870 | 0.2273802837649962
 | 2021-04-16 00:00:00 |  |  |  |  | 0.3310328288211469 |  |  |  |  |  | 2021-04-16 00:00:00 | 2467.5 |  |  | 77643.75 | 0.3310328288211469 |  | #N/A |  |  |  | 2021-04-16 00:00:00 | 540 |  |  | 31410 | 0.2313577814401856
 | 2021-04-23 00:00:00 |  |  |  |  | 0.3475218503517374 |  |  |  |  |  | 2021-04-23 00:00:00 | 3867.5 |  |  | 81511.25 | 0.3475218503517374 |  | #N/A |  |  |  | 2021-04-23 00:00:00 | 3567.5 |  |  | 34977.5 | 0.2576350461739603
 | 2021-04-30 00:00:00 |  |  | 2021-04-01 00:00:00 |  | 0.3085642720102323 |  |  |  |  |  | 2021-04-30 00:00:00 | -9137.5 | 4035 | 2021-04-01 00:00:00 | 72373.75 | 0.3085642720102323 | 0.4 | #N/A | 10000 |  |  | 2021-04-30 00:00:00 | 2267.5 | 7230 | 2021-04-01 00:00:00 | 37245 | 0.2743368535415381 | 0.4 |  | 20000
 |  |  |  |  |  |  |  |  | ↑
 |  |  |  |  |  |  |  |  | Desired result using dynamic functions using the value in B3 as the lookup and matching (with wildcard) M3 and [NAME].