I have been trying to count a number based on two range and criteria. but i can't solve it.
This is the data, i try to count how much cage between 100-200, 200-300 and if there was SPLIT count as +1 cage.
NO Cage's ABW(gr) Ket RANGE COUNT
1 NA02 491,04 SPLIT 100 TOTAL CAGE (SPLIT COUNT ONE)
2 NA05 710,99 SPLIT 200 TOTAL CAGE (SPLIT COUNT ONE)
3 NA07 172,95 300 TOTAL CAGE (SPLIT COUNT ONE)
4 NA08 266,66 400 TOTAL CAGE (SPLIT COUNT ONE)
5 NA09 529,19 SPLIT 500 TOTAL CAGE (SPLIT COUNT ONE)
6 NA12 463,06 SPLIT
7 NB01 778,13 SPLIT
8 NB02 927,84
9 NB06 781,99 SPLIT
10 NB07 721,78 SPLIT
11 NB09 42,00
12 NB10 935,68 SPLIT
13 NB12 498,63
14 NC01 121,93 TRIAL BEROK
15 NC03 41,38
16 NC05 779,26 SPLIT
17 NC06 41,38
18 NC07 41,58
19 NC11 537,20 SPLIT
20 ND01 571,45 SPLIT
What I have tried:
i've trying using countifs + if but still does'nt get the answer