Spreadsheet: 108113d1305211008-return-range-address-by-criteria-range-sum-test
Sheet: Sheet1

PF | LMV | SMV | RANGE | RNG NAME L | RNG NAME S | SUM TOP 5 LMV | SUM TOP 5 SMV | IN L TOP 5 Y/N | IN S TOP 5 Y/N
GT1 | 500000 | -1235 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 50500 | -574651213 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265 |  | Y
GT1 | 5462 | -4673 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 546123 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 5846 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 5874684 | -53432 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265 | Y
GT1 | 87983 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 24138 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 4896 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 |  | -42 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 |  | -5456 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 |  | -4313 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 5468 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 549 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 897632 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265 | Y
GT1 |  | -4683221 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265 |  | Y
GT1 | 873 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 |  | -54853 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 87968651 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265 | Y
GT1 | 54 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 854623 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265 | Y
GT1 | 23489 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 57432 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 |  | -51313 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 |  | -5468432 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265 |  | Y
GT1 |  | -521323 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 |  | -23132 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 564651321 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265 | Y
GT1 | 323 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 69 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 9543 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 35894 | -546513 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265 |  | Y
GT1 | 5965 | -2132 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 474 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 484 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 34 | -5456121 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 84 | -6595 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265 |  | Y
GT1 | 327454 | -543 | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 38 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 4 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 6 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT1 | 84 |  | A2:A43 | GT1L40675 | GT1S40675 | 660246911 | -8265
GT2 |  | -2412 | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442 |  | Y
GT2 | 545321 | -54544452 | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442 |  | Y
GT2 | 29964 |  | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442
GT2 | 6591 |  | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442
GT2 | 11848 |  | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442
GT2 | 648663 |  | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442 | Y
GT2 |  | -51132 | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442 |  | Y
GT2 |  | -541321 | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442 |  | Y
GT2 |  | -241 | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442
GT2 | 45465213215 | -1213 | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442 | Y
GT2 | 442513 | -444 | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442
GT2 | 1136415 |  | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442 | Y | Y
GT2 | 874963 |  | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442 | Y | Y
GT2 | 546132 |  | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442 | Y | Y
GT2 | 54653 |  | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442
GT2 |  | -52132 | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442 |  | Y
GT2 | 34863 |  | A44:A60 | GT2L40675 | GT2S40675 | 45468419388 | -55442
GT3 | 453321 |  | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294 | Y
GT3 | 6541 | -5453 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 | 54542 |  | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294 | Y
GT3 |  | -48669893 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294 |  | Y
GT3 |  | -12354 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 |  | -123216854 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294 |  | Y
GT3 | 52413 |  | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294 | Y
GT3 |  | -12132 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 |  | -12 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 | 2123 |  | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 | 545 |  | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 | 24111 |  | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 |  | -51546 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 |  | -125 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 | 21213 | -1213 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 |  | -121321 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 | 213 | -1231651 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 |  | -2413213 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 |  | -42132 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 |  | -45234 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 | 84487 | -2421 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294 | Y
GT3 |  | -51321321 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294 |  | Y
GT3 |  | -5213231 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294 |  | Y
GT3 |  | -12345 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 |  | -5484 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 | 854836 | -45432 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294 | Y
GT3 |  | -465432 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 |  | -4523 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 |  | -4531 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 |  | -23132 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294
GT3 |  | -4532132 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294 |  | Y
GT3 |  | -452313 | A61:A92 | GT3L40675 | GT3S40675 | 1499599 | -8294