Try these

=SUMIF(F8:F36,">100")

and

=SUMIF(F8:F36,"<=100")

VBA Noob