I'm trying to get a percentile for a range, and I've tried various ways of
adding "=PERCENTILE" to the following range or restating the range.

=SUMIF($A$2:$A$8000,"<=180")-SUMIF($A$2:$A$8000,"<-7")

any suggestions?