Spreadsheet: 758328d1638819544-sumifs-options-when-dependent-on-more-than-one-column-to-match-criteria-sum-if-help_ex1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | Jan-20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-02-01 00:00:00 |  |  | Feb-20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-03-01 00:00:00 |  |  | Mar-20
 | Sum Value based on month/yr and location from "Raw Data" table in columns I- Y |  |  |  | Oct-21 |  |  | Raw Data |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00 |  |  | Apr-20
 | Location |  |  |  |  |  |  | Location | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | Jul-22 | Aug-22 | Sep-22 | Oct-22 | Nov-22 | Dec-22 |  |  | 2020-05-01 00:00:00 |  |  | May-20
 |  |  |  |  |  |  |  | APPLE 5 STATE SWD 1 | 110503 | 140354 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00 |  |  | Jun-20
 |  | 494255 |  |  |  |  |  | AQUAMAN SWD 1 | 548432 | 494255 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00 |  |  | [NAME]
 |  | 25659.25 |  |  |  |  |  | BEBIDAS 16 STATE SWD 1 | 28940 | 25659.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-01 00:00:00 |  |  | Aug-20
 |  | 425683 |  |  |  |  |  | BERRY SWD 1 | 381985 | 425683 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00 |  |  | Sep-20
 |  | 630094 |  |  |  |  |  | BROWN SWD 1 | 539912 | 630094 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00 |  |  | Oct-20
 |  | 767986 |  |  |  |  |  | CORRAL FLY STATE SWD 1 | 581242 | 767986 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00 |  |  | Nov-20
 |  | 52520.93 |  |  |  |  |  | COTTONWOOD 2 STATE SWD 1 | 51485 | 52520.93 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00 |  |  | Dec-20
 |  | 54873 |  |  |  |  |  | COTTONWOOD 36 STATE SWD 1 | 52651 | 54873 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00 |  |  | Jan-21
 |  | 289664 |  |  |  |  |  | COUPES SWD 1 | 225420 | 289664 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-02-01 00:00:00 |  |  | Feb-21
 |  | 87876 |  |  |  |  |  | DEETS 1 SWD | 68643 | 87876 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-03-01 00:00:00 |  |  | Mar-21
 |  | 281835 |  |  |  |  |  | DJK 48 SWD 1 | 302244 | 281835 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00 |  |  | Apr-21
 |  | 0 |  |  |  |  |  | EATA FAJITA 8 STATE SWD 1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00 |  |  | May-21
 |  | 0 |  |  |  |  |  | EDDY STATE SWD 2 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-01 00:00:00 |  |  | [NAME]
 |  | 493228 |  |  |  |  |  | FOGELL SWD 1 | 438438 | 493228 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-01 00:00:00 |  |  | [NAME]
 |  | 44640 |  |  |  |  |  | GLENN 1 SWD | 82078 | 44640 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-01 00:00:00 |  |  | Aug-21
 |  | 195172.45 |  |  |  |  |  | GOLD COAST 26 FED SWD 1 | 150213 | 195172.45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-09-01 00:00:00 |  |  | Sep-21
 |  | 732688 |  |  |  |  |  | GOLDENEYE SWD 1 | 602417 | 732688 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-10-01 00:00:00 |  |  | Oct-21
 |  | 135319 |  |  |  |  |  | GRISSOM 1 SWD | 135835 | 135319 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-11-01 00:00:00 |  |  | Nov-21
 |  | 546496 |  |  |  |  |  | IRON MAN SWD 1 | 614468 | 546496 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-12-01 00:00:00 |  |  | Dec-21
 |  | 277516 |  |  |  |  |  | [NAME] | 336702 | 277516 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 |  |  | Jan-22
 |  | 370557 |  |  |  |  |  | LOBO 285 STATE SWD 1 | 80667 | 370557 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-02-01 00:00:00 |  |  | Feb-22
 |  | 19576.25 |  |  |  |  |  | MACHO NACHO 7 STATE SWD 1 | 17228 | 19576.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-03-01 00:00:00 |  |  | Mar-22
 |  | 337433 |  |  |  |  |  | MAD COW SWD 1 | 480758 | 337433 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-01 00:00:00 |  |  | Apr-22
 |  | 49936.64 |  |  |  |  |  | MAGNUM PRONTO 32 STATE SWD 1 | 36650 | 49936.64 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-05-01 00:00:00 |  |  | May-22
 |  | 355639 |  |  |  |  |  | MCLOVIN SWD 1 | 296164 | 355639 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-01 00:00:00 |  |  | Jun-22
 |  | 133552 |  |  |  |  |  | M F KING SWD 2 | 149187 | 133552 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-07-01 00:00:00 |  |  | Jul-22
 |  | 499318 |  |  |  |  |  | MOBLEY SWD 1 | 375111 | 499318 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-08-01 00:00:00 |  |  | Aug-22
 |  | 102576 |  |  |  |  |  | MOMENTUM 36 STATE 1 | 74485 | 102576 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-09-01 00:00:00 |  |  | Sep-22
 |  | 0 |  |  |  |  |  | NORTH LUSK 32 STATE SWD 1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-10-01 00:00:00 |  |  | Oct-22
 |  | 0 |  |  |  |  |  | PECOS RIVER 11 SWD 1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-11-01 00:00:00 |  |  | Nov-22
 |  | 820912 |  |  |  |  |  | PILLARD SWD 1 | 779361 | 820912 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-01 00:00:00 |  |  | Dec-22
 |  | 580977 |  |  |  |  |  | PILLARD SWD 2 | 355349 | 580977
 |  | 53962.75 |  |  |  |  |  | PINE SPRINGS 2 STATE SWD 1 | 47256 | 53962.75
 |  | 39612.58 |  |  |  |  |  | PINTAIL 3 FED SWD 1 | 42952 | 39612.58
 |  | 487479 |  |  |  |  |  | ROBERTSON ROJO SWD 1 | 490118 | 487479
 |  | 226384 |  |  |  |  |  | SCHMITT STATE 1 SWD | 165645 | 226384
 |  | 302909 |  |  |  |  |  | STATE HU COM SWD 1 | 298703 | 302909
 |  | 640498 |  |  |  |  |  | SUPERBAD SWD 1 | 723901 | 640498
 |  | 516192 |  |  |  |  |  | THANOS SWD 1 | 634567 | 516192
 |  | 587936 |  |  |  |  |  | TROVE ENERGY SWD 1 | 460679 | 587936
 |  | 636585 |  |  |  |  |  | WATERBOY SWD 1 | 624528 | 636585
 |  | 270228 |  |  |  |  |  | WILLOW 17 STATE SWD 1 | 193732 | 270228
 |  | 46396 |  |  |  |  |  | WISHBONE 1 SWD | 44802 | 46396