...
11.4 Group by segment
Here below is a data table:
We want to count the number of people in each of the following score segments respectively: below 50, 50-60, 60-70, 70-80, 80-90 and above 90.
=spl("=E(?1).groups(if(Score<50:""<50"",Score>=50 && Score<60:""50-60"",Score>=60 && Score<70:""60-70"",Score>=70 && Score<80:""70-80"",Score>=80 && Score<90:""80-90"";"">=90""):Score;count(1):Num)",A1:C25)