CODEWITHSUNDEEP
openoffice.orgopenoffice-calc
Bouraoui Al-Moez L.A
Bouraoui Al-Moez L.A

Reputation: 989

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

Upvotes: 0

Views: 112

Answers (1)

cojody
cojody

Reputation: 56

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

Upvotes: 2

Related Questions