Spreadsheet: 841605d1693798200-check-cell-value-look-in-a-a-for-cell-then-count-all-in-range-to-meet-criteria-excel-forum
Sheet: Sheet1

 | Gas Weights |  | Total count |  |  |  |  |  | cell | [NAME]
 | Overall | from | 2022-09-17 00:00:00 |  |  |  |  |  | INV # | 7 |  |  | days |  |  |  | XS
 | Oldest days |  | #[NAME] |  |  |  |  |  | AVG days |  |  |  |  |  |  | 200 | S
 | Youngest days |  | #S |  |  |  |  |  | Low gms |  | #S |  |  |  |  | 300 | M
 | AVG days |  | #M |  |  |  |  |  | High gms |  | #M |  |  |  |  | 400 | L
 |  |  | #L |  |  |  |  |  | AVG gms |  | #L |  |  |  |  | 550 | XL
 | Low gms |  | #XL |  |  |  |  |  |  |  | #XL |  |  |  |  | 750 | XXL |  | [NAME] for cell [NAME]
 | High gms |  | #XXL |  |  |  |  |  |  |  | #XXL |  |  |  |  | 1000 | XXXL |  | I want to look at number in cell K2
 | AVG gms |  | TOTAL |  |  |  |  |  |  |  | TOTAL |  |  |  |  | 1100 |  |  | then find all cells in A13 down that = K2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | now look at the range "Weights" A13:X1000 that are the rows = to K2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | And apply formula =COUNTIFS(Weights,">=200",Weights,"<=299") for the rows in A:A that are same as K2
INV | Date | Cage | DOB | AGE Days | Weights | Weights | Weights | Weights | Weights | Weights | Weights | Weights | Weights | Weights | Weights | Weights
7 | 2023-07-22 00:00:00 | 34 |  |  | 421 | 428 | 260 | 287 | 356 | 437 | 424 | 457 |  |  |  |  |  |  | [NAME] for cell M5
7 | 2023-07-20 00:00:00 | 27 |  |  | 391 | 428 | 457 | 384 | 414 | 506 | 356 | 414 |  |  |  |  |  |  | I want to look at number in cell K2
7 | 2023-07-20 00:00:00 | 26 |  |  | 675 | 751 | 672 | 705 | 865 | 844 | 783 |  |  |  |  |  |  |  | then find all cells in A13 down that = K2
7 | 2023-07-20 00:00:00 | 32 |  |  | 616 | 633 | 583 | 628 | 589 |  |  |  |  |  |  |  |  |  | now look at the range "Weights" A13:X1000 that are the rows = to K2
7 | 2023-07-20 00:00:00 | 5 |  |  | 906 | 921 | 907 |  |  |  |  |  |  |  |  |  |  |  | And apply formula =COUNTIFS(Weights,">=300",Weights,"<=399") for the rows in A:A that are same as K2
7 | 2023-07-23 00:00:00 | 20 |  |  | 668 | 764 | 656 | 663
7 | 2023-07-23 00:00:00 | 11 |  |  | 275 | 317 | 423 | 297 | 326 | 294 | 376 |  |  |  |  |  |  |  | Following Size_Key to fill down to M8
7 | 2023-07-23 00:00:00 | 18 |  |  | 384 | 508 | 486 | 450 | 501 | 515 | 411 | 536
7 | 2023-07-23 00:00:00 | 2 |  |  | 398 | 441 | 298 | 393 | 391 | 398 | 362 | 431 | 414
7 | 2023-08-03 00:00:00 | 35 |  |  | 982
7 | 2023-08-06 00:00:00 | 3 |  |  | 808 | 473 | 613 | 629 | 594 | 685 | 720
7 | 2023-08-06 00:00:00 | 11 |  |  | 473
7 | 2023-08-06 00:00:00 | 12 |  |  | 572 | 536 | 458 | 545 | 426 | 470 | 430 | 478
7 | 2023-08-06 00:00:00 | 25 |  |  | 377 | 314 | 413 | 344 | 316 | 367 | 383 | 234
7 | 2023-08-06 00:00:00 | 34 |  |  | 252 | 250 | 291 | 285 | 362 | 368 | 372 | 336
7 | 2023-08-10 00:00:00 | 34 |  |  | 650
7 | 2023-08-10 00:00:00 | 3 |  |  | 965 | 968 | 939
7 | 2023-08-10 00:00:00 | 33 |  |  | 281 | 294 | 281 | 247 | 270 | 279
7 | 2023-08-10 00:00:00 | 14 |  |  | 270 | 354 | 323 | 235 | 303
7 | 2023-08-13 00:00:00 | 61 |  |  | 261
7 | 2023-08-13 00:00:00 | 31 |  |  | 290 | 221
7 | 2023-08-17 00:00:00 | 73 |  |  | 648 | 795 | 650 | 577 | 825 | 612 | 800 | 695
7 | 2023-08-17 00:00:00 | 17 |  |  | 281 | 234 | 393
7 | 2023-08-17 00:00:00 | 9 |  |  | 391 | 679
7 | 2023-08-20 00:00:00 | 59 |  |  | 681 | 663 | 602
7 | 2023-08-17 00:00:00 | 42 |  |  | 826 | 854 | 827 | 875
7 | 2023-08-17 00:00:00 | 63 |  |  | 689 | 705 | 692
7 | 2023-08-24 00:00:00 | 38 |  |  | 420 | 366 | 420 | 455 | 419 | 420 | 415 | 440
7 | 2023-08-24 00:00:00 | 61 |  |  | 531
7 | 2023-08-24 00:00:00 | 40 |  |  | 341 | 745 | 745 | 777
7 | 2023-08-24 00:00:00 | 76 |  |  | 677 | 635 | 600 | 650
8 | 2023-09-02 00:00:00 | 44 |  |  | 800 | 812 | 720 | 813 | 648 | 785 | 566 | 608
8 | 2023-09-02 00:00:00 | 41 |  |  | 665 | 618 | 700 | 736
8 | 2023-09-02 00:00:00 | 51 |  |  | 505 | 431 | 257 | 375