I have a range of values F1:F144 and i want to make sum of values less than 50.
I tried =SUM(F1:F144,'<'50) but it doesn't work (i don't want to sort them).
=SUM(F1:F144,'<'50)
Try this: =SUMIF(F1:F144;"<50")
=SUMIF(F1:F144;"<50")