openoffice.orgopenoffice-calc

OpenOffice Calc sum of number less then a value


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).


Solution

  • Try this: =SUMIF(F1:F144;"<50")