Spreadsheet: 735260d1622800771-sumifs-w-multiple-criteria-including-summation-between-specific-months-sumifs-help-needed
Sheet: Lookup Table

 | Note: Ficticious data using RANDBETWEEN function
 |  |  |  |  | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_Atlantic | ATLANTIC MARKET | 2 | 22 | 41 | 60 | 42 | 68 | 69 | 12 | 14 | 19 | 69 | 19
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_California | CALIFORNIA MARKET | 28 | 73 | 50 | 78 | 50 | 66 | 56 | 19 | 81 | 66 | 33 | 11
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_Central TX | CENTRAL TEXAS MARKET | 83 | 65 | 13 | 67 | 71 | 26 | 35 | 25 | 24 | 4 | 59 | 21
 | MEDICAL FI (2-50) Community Rated | Direct Channel | [NAME] Total | DESERT STATES MARKET | 32 | 37 | 9 | 71 | 22 | 10 | 41 | 1 | 65 | 49 | 58 | 6
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_Georgia | GEORGIA MARKET | 16 | 56 | 40 | 70 | 39 | 39 | 55 | 47 | 48 | 65 | 69 | 82
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_Houston | HOUSTON MARKET | 9 | 6 | 58 | 37 | 8 | 22 | 64 | 46 | 58 | 23 | 55 | 62
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_Illinois | ILLINOIS MARKET | 81 | 16 | 41 | 75 | 74 | 28 | 78 | 81 | 71 | 5 | 8 | 73
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_Kansas-Missouri | KANSAS-MISSOURI MARKET | 7 | 77 | 74 | 72 | 9 | 55 | 2 | 12 | 25 | 40 | 15 | 64
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_Kentucky | KENTUCKY MARKET | 85 | 46 | 9 | 74 | 21 | 57 | 66 | 76 | 11 | 1 | 80 | 58
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_Louisiana | LOUISIANA MARKET | 26 | 12 | 12 | 48 | 29 | 12 | 39 | 39 | 84 | 23 | 84 | 0
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_Mountain States | MOUNTAIN STATES MARKET | 60 | 70 | 32 | 8 | 60 | 41 | 50 | 74 | 33 | 71 | 40 | 65
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_North Florida | NORTH FLORIDA MARKET | 84 | 48 | 44 | 21 | 4 | 24 | 10 | 28 | 0 | 59 | 35 | 9
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_North TX | NORTH TEXAS MARKET | 39 | 76 | 74 | 77 | 45 | 80 | 20 | 57 | 9 | 14 | 32 | 58
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_Ohio | OHIO MARKET | 61 | 8 | 7 | 56 | 2 | 78 | 47 | 29 | 8 | 71 | 0 | 10
 | MEDICAL FI (2-50) Community Rated | Direct Channel |  |  | 67 | 24 | 4 | 72 | 60 | 62 | 69 | 33 | 43 | 56 | 49 | 45
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_South Florida | SOUTH FLORIDA MARKET | 27 | 12 | 15 | 23 | 63 | 65 | 78 | 42 | 18 | 39 | 21 | 13
 | MEDICAL FI (2-50) Community Rated | Direct Channel | [NAME] | SOUTH TEXAS MARKET | 12 | 34 | 3 | 36 | 85 | 43 | 13 | 8 | 50 | 49 | 40 | 66
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_Tennessee | TENNESSEE MARKET | 59 | 55 | 25 | 52 | 26 | 72 | 80 | 16 | 8 | 55 | 6 | 31
 | MEDICAL FI (2-50) Community Rated | Direct Channel | C_Wisconsin | WISCONSIN MARKET | 28 | 68 | 5 | 38 | 41 | 49 | 23 | 20 | 81 | 44 | 58 | 72